Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart w/Secondary Axis
I'm trying to create a chart that shows dollar values on one side and % on
the other. There are a total of 5 data series that need to show on the secondary axis, ranging from -3% to 45%. I can not get all of the data series to show up on the chart. I've been able to get 2 of the 5 to show up by just right clicking around the chart. I've changed the range of values on the secondary axis to show -5% to 50% and they still don't show up. Any suggestions would be greatly appreciated!! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart w/Secondary Axis
Don't use the built in types with two axes. Put all your data into the chart
using a single chart type. Then if you want to use a different type for some series , select each series, then use Chart menu Chart Type to change it. Then double click on a series, and change the axis selected on the Axis tab. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jazyfish" wrote in message ... I'm trying to create a chart that shows dollar values on one side and % on the other. There are a total of 5 data series that need to show on the secondary axis, ranging from -3% to 45%. I can not get all of the data series to show up on the chart. I've been able to get 2 of the 5 to show up by just right clicking around the chart. I've changed the range of values on the secondary axis to show -5% to 50% and they still don't show up. Any suggestions would be greatly appreciated!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bar chart with XY on secondary axis | Charts and Charting in Excel | |||
Double-stacked Bar Chart WITH a Secondary Y Axis Line chart? | Charts and Charting in Excel | |||
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 | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel |