I have a chart of type 'Line' that shows a KPI item measured quarterely. It has a single series that references the 'data' worksheet. Since it is measured quarterely, the months in between will have a null value. It has been working to date, but since I have added the data for the latest month, the series line has disappeared. Only the markers remain. The series line is formatted in a vivid blue.
I can't attach the spreadsheet because its 152KB. One thing of note is that when I select the series line, not all of the markers get highlighted as expected
Sub Macro5() ActiveSheet.ChartObjects("Chart 243").Activate ActiveSheet.ChartObjects("Chart 243").Activate ActiveChart.SeriesCollection(1).Delete ActiveChart.SeriesCollection(2).Delete End Sub
However, if there is no SereisCollection(1) actually present in the chart I get an error. How can I work around this? I will need an IF statement I assume, just not sure what it will look like.
Is there any possible to add a series to a graph table without having the line in the Graph. i just want to show the difference for information and not in the graph?
i have tried some different things (like having the difference in white so it is not visible, formatting the Axis etc)
I'm using this code to split a series line into 2 overlapping parts, so I can use different styles on them:
Code:
Sub backfillDataSeries() 'make new series in Port Historical Risk 'if there is a backfill date in Rolling window data Dim cRange As Range Dim i As Integer
[Code]....
This is how the line looks before I run the code:
And this is how it looks afterwards:
I think it prints mirrored. Can I get a mirror image of the 2nd line?
Jan Feb Mar Apr May 2009years 56 45 42 50 62 - series1 2010years 48 47 45 48 55 - series2
I need make line chart from 3 series. First two are series1 and series2. Third is percent change between 2010 and 2009 years every month (series3). First two are easy, but third is very difficult for me, becouse I haven't row with percent change and I can't haven't it in my exercise.
How can I make it without new row with percent change?
I tried it with Data Source in chart, also formula in Name Manager, but it doesn't succeed
I am trying to produce a line chart, which will use imported data on a separate sheet (but within the same workbook)
The imported data can be of different sizes ie column widths and length. Some columns may contain only zero and should not be included in the chart, and will be to right of the data.
I have created a named range for the data series called ChartData using =OFFSET(Data!$C$1,0,0,info!$C$7,info!$A$2) - C7 and A2 are calculations to set column and row sizes. I have tried to use this as the chart's data series, but without success.
Im plotting data on a Line-Column 2 Axes Chart which works really well with 4 data series (2 column, 2 Line) but when adding a fifth data series, the fourth disappears from view. I can see its still there cos I can display the values but I cant get the line to appear. The values for the 5th series are also similar to other series values so its not like the chart cant display it....are there limits to the number of series on such a chart?
Is there a way to add comment text at a 45 degree angle to an excel chat?
What I need to do is to add a comment parallel to a 45 degree line on an excel chart, and the text box dosen't give you the option t have 45 degree text.
I want to add a user-form on a chart, which will have check-boxes that will allow me to select series(lines) that I want see and compare in a chart. Currently my line chart has 24 series (Lines) which makes the chart very difficult to view and looks very busy. How do I add list of check-boxes that will allow me to select one or multiple lines that I want to see at a time?
I am trying to create a line graph that will incorporate multiple columns of data in one series of data. The reason I do not place all of the data in one column is because it could exceed the maximum amount of rows allowed in excel. Also I need the data split up for viewing purposes.
I can easily just graph one column but how do I combine all the columns into one line graph with the data being in separate columns. Basically all the columns will be my Y values and X values are just 1:n.
Example Below:
Column AColumn B Column C159261037114812
Now in the example all of the values are x values.
I have created some drop-down boxes on a tracking spreadsheet. Last week they were they today they are gone.
I went in and cleared the cells and re-created by dropdowns. I did remember to click, in-cell dropdown, but when I click on the cell it is not there.
Now if I right click on the cell it does give me an option to choose from a drop down. So my options are still there but why are they not appearing in the cell when I click on it.
I am unable to view my tabs in excel - the tabs are there, they just can't be clicked on per say. I have double-check the tools option and verified the correct box is check to view tabs, however, I can't view the tabs. I tried to color a tab and it colored it red, but I can't really view the tab. I can see a red line underneath the directional arrows when I am working on that particular worksheet, but again, I can't view/click on the tab.
Was working away on one of my spreadsheets and the black square that surrounds the cell you click on has vanished. i.e. if you click on cell A1, you normally get a black square surrounding the cell A1 to let you know that you are on it. That black square has disappeared.
It seems to affect any spread that I open but if I open a new spreadsheet it is there.
I have used this file extensively for months. I inadvertently clicked something this morning that made the file "disappear". I can see the file in its folder and open it. But, once opened, I do not see any of the tabs and the name of the file does not appear at the top. I did ALT F11 and can see the tabs in the VBA but I'm missing a step to make the tabs reappear. Since I don't know what I did to make everything disappear,
Just curious as to what could make a custom menu or custom button disappear from Excel upon opening it. I had created a custom menu with personal.xls macros in it for someone here a while back, and today it was completely missing.. although the Personal.xls folder still existed with the macros.
I am quite sure that they did not manually remove the menu by right-clicking and selecting Customize and dragging back the menu items...
Column A disappeared and didn't come back. I even arrow over to the left margin, but the furthest it goes is to column B. How can I get my column A back?
I have been presented with a rather odd thing with Excel. We have a wookbook with six worksheets in it. When the first of worksheets is displayed, all the other tabs "disappear". The whole bottom tool/navigation bar is no longer displayed. How can I get it back?
I've created a sheet with a number of drop down lists using the validation menu.
Whilst working on the sheet the lists have disappeared! The validation options are still there and refer to the correct cells that have the correct details in them, but when I click in the cell that should have the list in it I don't get the down arrow to click that shows the list.
I've also tried creating a new list in another cell but that does the same.
Hopefully i've just changed a setting that stops it working and I can unchange it - but I don't know what's caused it.
When I go to excel ==> ALT + F11 ==> Tools ==> Reference ==> I can't seem to find "solver" anymore. My code was using the solver module, and now my code does not work. I can't find "solver" to check it.
From time to time, the status bar in excel 2010 is not showing (I don't mean the information is not showing, I mean the bar is not there at all). In previous versions I would go to view>status bar...
My boss has passed me his laptop that he had been designing a spreadsheet on (Excel 2000). The 'forms' toolbar has completely disappeared. When I right click the area where the toolbars are normally docked it lists every one except forms. clicking customise appears to list a few more menus - but no sign of FORMS. If I click 'new' in customise and type in Forms for the name it tells me 'a toolbar named 'forms' already exists' (so where is it!)
I run a large simulation experiment. I have a loop plotting data in excel of a user defined area. Because of the limit of 255 series I have allowed a maximum of 250 simulations (they all need to be plotted). But the length of each simulation is free. I know there is a limit of 32.000 data points in a graph and I have this as a condition too.
If I set the data range to 100 columns and 3000 rows the graph is produced when I plot by columns. (code below)
But if I set the data range to 250 columns and 1000 rows I get the above mentioned error message. Even though I only have 250 series.
After the data is plotted it is the code below that gets the error:
I just recently installed Excel 2007 and I would like to know if it's possible to change all data points of a chart at the same time. In Excel 2003, I would normally hold down shift while clicking on each of the data points to make a global change. However, it appears I cannot do that in 2007.
I would like to display each data point's series name. When I go to Layout on the Excel Ribbon, and click on "Data Labels", and click on "More Data Label Options", the actual Y-axis values are shown for each data point. However, I do not want this - I actually only want the Series Name, but when I uncheck "Value" and check "Series Name" instead (under "Label Contains"), it only changes it for one of the series. Is there a better way, instead of going through each and every single series to make this change?
