LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default 3 values on Y axes

Joe -

You have (at least) three options:

* Make three different charts

* Make one chart with primary, secondary, and tertiary axes. Excel doesn't
come with tertiary axes, but that's never stopped me:

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

* Make one chart, with each series (or set of series) plotted within its own
region of the chart. This is the trickiest since you have to jury-rig three
axes, not just one as in the Tertiary Axis option.

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

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


"Joe W" wrote in message
...
I have 3 widely varying values that I'm trying to plot. I have 2 Y axes
(which take care of 2 values). The third value is well outside the ranges
of
the other 2 and its fluctuations are too difficult to decipher. Is there
a
solution for this? It's as if I'm trying to create a 3rd Y axis! BTW,
I'm
using a line graph; the X axis is a date range.
--
Thanks,
Joe



 
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
hiding zero values in charts fascal Charts and Charting in Excel 4 December 19th 05 02:17 PM
Keeping a cell value constant trhoughout a list of values borikua05 Excel Worksheet Functions 2 December 3rd 05 03:03 PM
Count Intervals of 2 Consecutive Values in same Row and Return Count across Row Sam via OfficeKB.com Excel Worksheet Functions 6 November 29th 05 03:27 PM
I Need a formula to evaluate a cell with + or - values Bob in Oklahoma Excel Worksheet Functions 6 October 31st 05 02:41 PM
#N/A Values : Returned by Formulas vs Entered Manually monir Charts and Charting in Excel 8 July 7th 05 01:16 AM


All times are GMT +1. The time now is 06:35 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"