Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 553
Default Only 2 vertical axis?

I have a data showing

Sales In Millions
Clients In Thousands &
Rate In Percentage.

I can show Sales & Clients as bars on two vertical axes, but do I have an
option to show Rate as a raised line graph?
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Only 2 vertical axis?

What's a "raised" line graph?

You can fake a third vertical axis:

http://peltiertech.com/Excel/Charts/TertiaryAxis.html

but it typically clutters a chart. A panel chart is a better approach:

http://peltiertech.com/Excel/Charts/StackedCharts.html
http://peltiertech.com/Excel/ChartsH...venScales.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"FARAZ QURESHI" wrote in message
...
I have a data showing

Sales In Millions
Clients In Thousands &
Rate In Percentage.

I can show Sales & Clients as bars on two vertical axes, but do I have an
option to show Rate as a raised line graph?



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
Dual Vertical Y-Axis gvm Charts and Charting in Excel 2 May 3rd 07 01:10 PM
Dual Vertical Y-Axis John G. Charts and Charting in Excel 2 March 15th 07 01:12 PM
can I make the vertical axis the category axis in Excel line graph power1 Charts and Charting in Excel 1 March 20th 06 08:45 PM
Need vertical separators rising from the X axis. Peter Jason Charts and Charting in Excel 1 January 2nd 06 11:53 AM
Suppressed 0's on the vertical axis in Excel '97 Literalgar Charts and Charting in Excel 1 June 10th 05 12:33 PM


All times are GMT +1. The time now is 12:23 PM.

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

About Us

"It's about Microsoft Excel"