| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Column Chart with multiple vertical axis
I tried building a chart that displays 1 series in dollar sales and 1 series
in unit sales. I tried putting one on a secondary axis, but it always overlaps the columns and changing the series overlap setting doesn't seem to have any effect? Does any one know what is going on and how I can separate columns on separate axis? Thanks, Jamie |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Column Chart with multiple vertical axis
You need to add a couple dummy series to help align the visible series:
http://peltiertech.com/Excel/Charts/...OnTwoAxes.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jamie" wrote in message ... I tried building a chart that displays 1 series in dollar sales and 1 series in unit sales. I tried putting one on a secondary axis, but it always overlaps the columns and changing the series overlap setting doesn't seem to have any effect? Does any one know what is going on and how I can separate columns on separate axis? Thanks, Jamie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| column chart stacks data when i add a secondary vertical axis | Charts and Charting in Excel | |||
| make chart with both horizontal-x axis vertical-y axis | Charts and Charting in Excel | |||
| Add vertical lines to a line chart (already has 2 Y axis) | Charts and Charting in Excel | |||
| Text is missing along the vertical axis of the chart (Y label). | Charts and Charting in Excel | |||
| Text Truncated on Vertical Chart Axis Label | Excel Discussion (Misc queries) | |||
Linear Mode
