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) |