Chart Axis uncooperative or misunderstood

[BDD2015]

Struggling with the axis in charts. Either I am trying to add too much or I don't understand the minimum and maximum values. If anyone can take a minute to enlighten me I'd appreciate it.

[BadlySpelledBuoy]

Going to need a little more information to go on than that!
What are you actually trying to achieve?

BSB

[BDD2015]

So, I am a little closer to what I want but I am not understanding why the line axis extend beyond the weeks or how I can get them to align.

[BadlySpelledBuoy]

Is this any better?

BSB

[BDD2015]

Looking at previous posts here kinda figure out the min. and max. values. But can't figure out why the line axis for difference between... and % don't align with the weeks.

[BDD2015]

haha. Yes, indeedy. Can you explain what I wasn't doing?

[BadlySpelledBuoy]

The ranges for your "Planned PPH", "Actual PPH" and the X axis were starting in row 6 whereas the rest were starting in row 7, so everything was a little off kilter.

Change the ranges to match and everything sorts itself out.

BSB

[BDD2015]

Absolutely right. Took me a minute to find what you meant. Everyday I learn something new about this "brain tumor causing" yet enjoyably addictive program. Thank you for your help BSB.

[BadlySpelledBuoy]

Happy to help.

As for learning something new every day with Excel.... I've been doing that for 20 years with it and it's still enjoyably addictive to me too.

BSB