Big Monkey
Active Member
- Joined
- Nov 5, 2005
- Messages
- 255
Is it possible to have multiple scaling for different series?
Or can you have more than 1 primary/secondary axis? Like a tertiary or fourth axis?
Or is it possible to display multiple plot areas on one chart?
Here is what I want to do:
I need to chart values. One series has a scale from 0-5. A second series is in percentage from 0-35%.
OK, I'm good so far and with multiple chart types(column and line) and by putting the percentages on a secondary axis, I can show both values on the same chart.
Here is the booger. I also need to display 2 more values..one in time(minutes and seconds) and one in standard values that range from 0-100.000.
The scaling on these last 2 values doesn't matter. I don't have to chart those. What I do need to do is try and put each of these 2 values together with the column chart that ranges from 0-5.
I want to avoid text boxes so I don't have to manually do this once a month, but I'm not sure if it can be done. The last 2 values can be towards the bottom of the columns.
At first I was thinking of designating these values as names and using a named range with an offset formula like I do with my column values, but Excel only lists the last name when I do that...or all of the names...so that didn't work.
I'm really stumped here. Any ideas?
Or can you have more than 1 primary/secondary axis? Like a tertiary or fourth axis?
Or is it possible to display multiple plot areas on one chart?
Here is what I want to do:
I need to chart values. One series has a scale from 0-5. A second series is in percentage from 0-35%.
OK, I'm good so far and with multiple chart types(column and line) and by putting the percentages on a secondary axis, I can show both values on the same chart.
Here is the booger. I also need to display 2 more values..one in time(minutes and seconds) and one in standard values that range from 0-100.000.
The scaling on these last 2 values doesn't matter. I don't have to chart those. What I do need to do is try and put each of these 2 values together with the column chart that ranges from 0-5.
I want to avoid text boxes so I don't have to manually do this once a month, but I'm not sure if it can be done. The last 2 values can be towards the bottom of the columns.
At first I was thinking of designating these values as names and using a named range with an offset formula like I do with my column values, but Excel only lists the last name when I do that...or all of the names...so that didn't work.
I'm really stumped here. Any ideas?