Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
how to do double "Y" axis bar chart
I would like to do a double "Y" axis bar chart for 2 variables with different
units against the same category (X variable). When I select "secondary Y" of the second data series bars are then stacked rather than adjacent. Thoughts? Thanks, Mike |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
how to do double "Y" axis bar chart
http://peltiertech.com/Excel/Charts/...OnTwoAxes.html
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "miked" wrote in message ... I would like to do a double "Y" axis bar chart for 2 variables with different units against the same category (X variable). When I select "secondary Y" of the second data series bars are then stacked rather than adjacent. Thoughts? Thanks, Mike |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
how to do double "Y" axis bar chart
Try switching it to columns, also go to custom charts in chart types scroll
down to "Lines and lines" or lines and bars and it will automatically set you up for 2 data types with a second catagory y axis "miked" wrote: I would like to do a double "Y" axis bar chart for 2 variables with different units against the same category (X variable). When I select "secondary Y" of the second data series bars are then stacked rather than adjacent. Thoughts? Thanks, Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel chart draws line outside Y axis | Charts and Charting in Excel | |||
negative [h]:mm:ss does not show on the x axis of a chart | Charts and Charting in Excel | |||
Column Chart - X axis too thin because of MANY categories. | Charts and Charting in Excel | |||
Chart Axis Value | Charts and Charting in Excel | |||
In a 2 Y-Axis chart, how do I assign data ranges to an axis? | Charts and Charting in Excel |