Home |
Search |
Today's Posts |
#1
|
|||
|
|||
2 Axis Chart
How do I choose which data seris will be bar vs. line? I read Barb R. post
and either I don't understand (very possible) or it doesn't work. Thanks |
#2
|
|||
|
|||
Mark -
Do you mean column (vertical) instead of bar (horizontal)? It's an important distinction because a column uses the same category axis as the line. Anyway, if you avoid the built-in combination chart types, you have complete control. Start with a column chart of all the data, then one by one, select each series you want to change to a line, and use the Chart Type command on the chart menu to change it. After changing one, you can select the next and press the F4 key, the shortcut to repeat the last action. Or start with a line chart of all the data, then one by one, select each series you want to change to a column, and use the Chart Type command on the chart menu to change it. If you are trying to make a combination chart with a line series and a horizontal bar series, with the line series using the vertical category axis, you need to fake it with an XY Scatter series: http://peltiertech.com/Excel/Charts/BarLineCombo.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Mark G wrote: How do I choose which data seris will be bar vs. line? I read Barb R. post and either I don't understand (very possible) or it doesn't work. Thanks |
#3
|
|||
|
|||
"Mark G" escreveu: How do I choose which data seris will be bar vs. line? I read Barb R. post and either I don't understand (very possible) or it doesn't work. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stacked Bar Chart with Secondary Axis | Charts and Charting in Excel | |||
How do I make the Y axis in an excel chart the category axis? | Charts and Charting in Excel | |||
How do I set permanent secondary axis in PivotTable chart? | Charts and Charting in Excel | |||
Second X axis at top of chart? | Charts and Charting in Excel | |||
Labels on Chart with Negative Value Axis | Charts and Charting in Excel |