| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Add line to horizontal bar chart
I've made a bar chart with horizontal bars (the Y axis running from left to
right as you look at the screen). I would like to convers my second series from a bar to a line, but whatyever I do Excel seems to create it on a secondary Y axis that is vertical. When I go into 'format data series' it won't let me plot it on the primary axis as the whole thing is greyed out. Can anybody help me? I'm working in Excel 97 by the way. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Add line to horizontal bar chart
Hi,
Have a look at these examples. http://www.andypope.info/charts/averageline.htm Cheers Andy Hrafn wrote: I've made a bar chart with horizontal bars (the Y axis running from left to right as you look at the screen). I would like to convers my second series from a bar to a line, but whatyever I do Excel seems to create it on a secondary Y axis that is vertical. When I go into 'format data series' it won't let me plot it on the primary axis as the whole thing is greyed out. Can anybody help me? I'm working in Excel 97 by the way. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Make a line in a bar chart, and change color of any bars that exceed the line | Excel Discussion (Misc queries) | |||
| Applying data as a line over an area chart | Charts and Charting in Excel | |||
| Change line in Chart | Charts and Charting in Excel | |||
| Line chart in Excel - trendline incomplete | Charts and Charting in Excel | |||
| Line chart - date line association gone mad! | Charts and Charting in Excel | |||
Linear Mode
