Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I add one line series to a bar graph?
I have a set of data for a budget. I have it set up as a bar grap with actual
data for 2004, and to-date 2005, budget 2005, and 2005 forecast for the rest of the year, I want to be able to change just the 2005 forecast information into a line. When I try to use the combination graph it forces half the data series to become lines the budget 2005 and the 2005 forecast for example. I can circumvent this problem by creating "dummy" data series equial to zero so that their lines are non-existant, but I think there has to be a way to set it up so that this isn't necessary |
#2
|
|||
|
|||
Elliott -
Don't use the "built-in custom" chart types. Besides being a strange oxymoron, built-in custom chart types are not very flexible. Make your own combination chart: Add the data as another column chart series. Select the new series, and using Chart Type from the Chart menu, choose a Line chart type. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Elliott wrote: I have a set of data for a budget. I have it set up as a bar grap with actual data for 2004, and to-date 2005, budget 2005, and 2005 forecast for the rest of the year, I want to be able to change just the 2005 forecast information into a line. When I try to use the combination graph it forces half the data series to become lines the budget 2005 and the 2005 forecast for example. I can circumvent this problem by creating "dummy" data series equial to zero so that their lines are non-existant, but I think there has to be a way to set it up so that this isn't necessary |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colour part of a line on an X Y graph | Charts and Charting in Excel | |||
how do I change a line series to a column series in excel? | Charts and Charting in Excel | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
series graph -- one series being added to another series | Charts and Charting in Excel | |||
Line and Column Graph | Charts and Charting in Excel |