Hi all,

I have a set of data that has 3 grouping, one has <10 per quarter, one has
between 30 - 80 per qtr and one has 1000 per quarter. I want to express this
as 3 lines on a graph but when i use a single scale i cannot read the lower
values. Is it possible to put 3 scales ona single axis.

Thanks in advance

Mike

Hi,

Here is an example with 2 y axis on one side, you can extend the idea:

http://peltiertech.com/Excel/Charts/TertiaryAxis.html

Instead, you might consider putting one on the right, the secondary scale.


--
Thanks,
Shane Devenshire


"Miketsw" wrote:

Hi all,

I have a set of data that has 3 grouping, one has <10 per quarter, one has
between 30 - 80 per qtr and one has 1000 per quarter. I want to express this
as 3 lines on a graph but when i use a single scale i cannot read the lower
values. Is it possible to put 3 scales ona single axis.

Thanks in advance

Mike