Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Bar chart with XY on secondary axis casey Charts and Charting in Excel 2 January 17th 08 05:46 PM
Double-stacked Bar Chart WITH a Secondary Y Axis Line chart? lpenndorf Charts and Charting in Excel 1 February 7th 07 05:32 PM
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? Dmitry Excel Discussion (Misc queries) 3 May 4th 06 01:58 AM
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? Dmitry Charts and Charting in Excel 2 May 4th 06 01:58 AM
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis [email protected] Charts and Charting in Excel 0 July 13th 05 09:30 PM


All times are GMT +1. The time now is 03:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"