Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
multiple series bar and line chart
Hello,
I am creating charts with 5 data series. I have it set up to create both bars and lines. (bars plotted agains primary y axis, lines against secondary y axis) However, it always sets the first four series to display as bars and the last one as a line. I need the first two as bars and the last three as lines. How do I force a series from one type to the other? I have already tried "plot series on secondary axis" but that only plots the bars against the second axis. it does not change them to a line. I am using excel 2003, and cannot use plugins. Only stock excel. Thanks |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
multiple series bar and line chart
Select the single series you want to change. Now goto Chart - Chart Type, and
change it to whatever you'd like. Repeat as needed for other series. Note that you will still need to move them over to the secondary axis, but you already know how to do that. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "David NGC" wrote: Hello, I am creating charts with 5 data series. I have it set up to create both bars and lines. (bars plotted agains primary y axis, lines against secondary y axis) However, it always sets the first four series to display as bars and the last one as a line. I need the first two as bars and the last three as lines. How do I force a series from one type to the other? I have already tried "plot series on secondary axis" but that only plots the bars against the second axis. it does not change them to a line. I am using excel 2003, and cannot use plugins. Only stock excel. Thanks |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
multiple series bar and line chart
Awesome! Thanks a lot.
"Luke M" wrote: Select the single series you want to change. Now goto Chart - Chart Type, and change it to whatever you'd like. Repeat as needed for other series. Note that you will still need to move them over to the secondary axis, but you already know how to do that. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "David NGC" wrote: Hello, I am creating charts with 5 data series. I have it set up to create both bars and lines. (bars plotted agains primary y axis, lines against secondary y axis) However, it always sets the first four series to display as bars and the last one as a line. I need the first two as bars and the last three as lines. How do I force a series from one type to the other? I have already tried "plot series on secondary axis" but that only plots the bars against the second axis. it does not change them to a line. I am using excel 2003, and cannot use plugins. Only stock excel. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line Chart with multiple series that have different date ranges | Charts and Charting in Excel | |||
User Selectable Series and Number of Series for Line Chart | Charts and Charting in Excel | |||
Varying colors on a line chart with multiple series | Charts and Charting in Excel | |||
Cutting a line in a line chart when data series stops | Charts and Charting in Excel | |||
Line chart, multiple series, data is inter-mixed | Charts and Charting in Excel |