Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Need help building chart to track trends between two different sets of data
Could you put one series on the secondary axis? Well, assuming you're
willing to dispense with the false 3D effects and revert to a standard area, line, or xy chart. Double click either series, and on the Axis tab, select Secondary. If you use Area charts, the secondary axis series will be in front of the primary axis series, so you either have to carefully select which to switch axes, or switch to a line chart, or maybe keep the primary axis series as an area type and switch the secondary axis series to a line type. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Jack Black" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding Data Information to a Chart | Charts and Charting in Excel | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Why doesn't my chart update when underlying data changes? | Charts and Charting in Excel | |||
Excel 2002 chart does not update when worksheet data changes | Charts and Charting in Excel | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |