| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Secondary Y axis
I created a chart with 2 axes: left axis is a line chart and right axis is a
bar chart. Both series have both positive and negative numbers. Problem is that both have their origin at 0 on the scale, but the 0 on the left axis is slightly higher than the zero on the right axis. Any ideas? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Secondary Y axis
Hi,
Have a look at, http://peltiertech.com/Excel/Charts/AlignXon2Ys.html Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "chadmh" wrote in message ... I created a chart with 2 axes: left axis is a line chart and right axis is a bar chart. Both series have both positive and negative numbers. Problem is that both have their origin at 0 on the scale, but the 0 on the left axis is slightly higher than the zero on the right axis. Any ideas? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Secondary Y axis
Beautiful. I ended up just doing the seventh grade algebra instead of using
the macro, but it worked great. Thanks. "Andy Pope" wrote: Hi, Have a look at, http://peltiertech.com/Excel/Charts/AlignXon2Ys.html Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "chadmh" wrote in message ... I created a chart with 2 axes: left axis is a line chart and right axis is a bar chart. Both series have both positive and negative numbers. Problem is that both have their origin at 0 on the scale, but the 0 on the left axis is slightly higher than the zero on the right axis. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to place a secondary y axis bar in a bar chart next to two primary y axis bars? | Excel Discussion (Misc queries) | |||
| How to place a secondary y axis bar in a bar chart next to two primary y axis bars? | Charts and Charting in Excel | |||
| Secondary Axis Match Primary Axis Gridlines | Charts and Charting in Excel | |||
| Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
| Secondary Axis Annual Units sold on 1 Y Axis - Dollar Volume on another | Charts and Charting in Excel | |||
Linear Mode
