Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
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 |