LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
Jack Black
 
Posts: n/a
Default Need help building chart to track trends between two different sets of data

Hi, all! I need to build a chart (for example, a 3D Area Chart) that will
display the trend between two disparate sets of data. Now, I can't have the
two side-by side, because one set of data falls in the 0-20 range(ish) while
the second contains large cash values (cost of a precious metal, for
example).

Is there any way to build this chart so the smaller set of data uses a
different scale than the second set of data, without displaying incorrect
values? I considered applying a factor to the small value data set, but
that just displays incorrect values on the axis.

Any suggestions would be helpful. I've seen some examples of a Split-Y axis
graph, but I'm not sure that'll work...
SteveB


 
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
Adding Data Information to a Chart Mike M Charts and Charting in Excel 4 December 17th 05 12:12 AM
Excel Macro to Copy & Paste [email protected] Excel Worksheet Functions 0 December 1st 05 01:56 PM
Why doesn't my chart update when underlying data changes? Marc Charts and Charting in Excel 3 November 19th 05 05:31 PM
Excel 2002 chart does not update when worksheet data changes proquant Charts and Charting in Excel 1 June 15th 05 12:23 AM
Extending a Chart Data Series from an Array - Can it be done? Jon Peltier Charts and Charting in Excel 4 November 30th 04 03:30 AM


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