So, I looked back at John's graph for the split axis and that won't help
me. But the concept of a dummy series may! The problem is, my math
(algegra, trig, calc...) is so rusty that I don't know where to begin to
make a correlation between the two axis.

My left axis scale is from 100K to 400K at 50K increments.

My right axis scale is from 16K to 22K at 1K increments.

My line graph references the right axis and I can eyeball it and pick a
number on the left axis to fill in. However, I'd like to be a bit more
accurate than just eyeballing it.

It's not as easy as saying "for every 1000 on the right, there's 50K on
the left" because the left starts at 100K (2 times the increment) and
the right starts at 16K (16 times the increment). I know there's a
simply logical way to figure this out, but I can't quite grasp it.

If anyone has an idea or thought, I'd love to hear it!

Thanks in advance!

Rita Brasher
Project Engineer / Int'l MIS and Analysis
FedEx Express

Hi,

I'm confused, what are you trying to do?
Split a single axis or align 2.

Cheers
Andy


Rita Brasher wrote:
So, I looked back at John's graph for the split axis and that won't help
me. But the concept of a dummy series may! The problem is, my math
(algegra, trig, calc...) is so rusty that I don't know where to begin to
make a correlation between the two axis.

My left axis scale is from 100K to 400K at 50K increments.

My right axis scale is from 16K to 22K at 1K increments.

My line graph references the right axis and I can eyeball it and pick a
number on the left axis to fill in. However, I'd like to be a bit more
accurate than just eyeballing it.

It's not as easy as saying "for every 1000 on the right, there's 50K on
the left" because the left starts at 100K (2 times the increment) and
the right starts at 16K (16 times the increment). I know there's a
simply logical way to figure this out, but I can't quite grasp it.

If anyone has an idea or thought, I'd love to hear it!

Thanks in advance!

Rita Brasher
Project Engineer / Int'l MIS and Analysis
FedEx Express

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

You know what? I've decided that what he wants to see makes no sense
because it will give a false impression. I'm going to use John's split
axis idea after all!

I'm going to send a file for you to look at if you get time.

Thanks Andy! YOU ROCK!!



Andy Pope wrote:
Hi,

I'm confused, what are you trying to do?
Split a single axis or align 2.

Cheers
Andy


Rita Brasher wrote:
So, I looked back at John's graph for the split axis and that won't
help me. But the concept of a dummy series may! The problem is, my
math (algegra, trig, calc...) is so rusty that I don't know where to
begin to make a correlation between the two axis.

My left axis scale is from 100K to 400K at 50K increments.

My right axis scale is from 16K to 22K at 1K increments.

My line graph references the right axis and I can eyeball it and pick
a number on the left axis to fill in. However, I'd like to be a bit
more accurate than just eyeballing it.

It's not as easy as saying "for every 1000 on the right, there's 50K
on the left" because the left starts at 100K (2 times the increment)
and the right starts at 16K (16 times the increment). I know there's
a simply logical way to figure this out, but I can't quite grasp it.

If anyone has an idea or thought, I'd love to hear it!

Thanks in advance!

Rita Brasher
Project Engineer / Int'l MIS and Analysis FedEx Express