Home |
Search |
Today's Posts |
#1
|
|||
|
|||
varying y-axis
i have 2 data sets with large discrepencies in values. i want to make a bar graph with the smaller set directly on top of the larger set, but if i do this, you can barely see the smaller set. i know that a log scale would work for this, but that's not what i need. is there a way to split the y-axis on a bar chart like there is for a scatter plot. that way the first bar could go up to, say 100, increments of 10, then there be a break in the y-axis and skip to 100,000. i would also need the increments to then increase after the split, say to 10,000. this seems relatively simple, but i can't seem to figure it out. thanks a lot.
|
#2
|
|||
|
|||
I'm guessing you are looking for something like this
http://www.peltiertech.com/Excel/Cha...kedCharts.html "etraleigh" wrote: i have 2 data sets with large discrepencies in values. i want to make a bar graph with the smaller set directly on top of the larger set, but if i do this, you can barely see the smaller set. i know that a log scale would work for this, but that's not what i need. is there a way to split the y-axis on a bar chart like there is for a scatter plot. that way the first bar could go up to, say 100, increments of 10, then there be a break in the y-axis and skip to 100,000. i would also need the increments to then increase after the split, say to 10,000. this seems relatively simple, but i can't seem to figure it out. thanks a lot. -- etraleigh |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can't change how data on 2nd axis is being displayed | Charts and Charting in Excel | |||
How do I make the Y axis in an excel chart the category axis? | Charts and Charting in Excel | |||
Varying axis scaling | Charts and Charting in Excel | |||
Second X axis at top of chart? | Charts and Charting in Excel | |||
Y axis, need varying units | Charts and Charting in Excel |