Chart Axis - Adding one?

Hi guys,

please see the attached. Imagine the the plots are for site page views (highest), visits and purchases (lowest) from a website analytics report.

Because there is such a high difference between the amount of purchases vs page views, it's hard to get an impression of what the figures were for page views, based on the left axis, which was set to increments of 2500.

How can I make another axis, on the right, with, for e.g. increments of 500? That way viewers can clearly see the statistical differences between the plots whilst preserving clarity.

Hard to explain, but hope you understand the Q...

Cheers,

Zudecke

Thanks for your quick reply.

Think we're progressing here, but look at the new attached screenshot and see what happens when I clicked Format Data Series > Secondary Axis - it's now shrunk the page views plot and enlarged the purchases plot..

All I wanted was to show two different axis basically displaying different increments (major values) so you could more clearly differentiate between the two as the difference was quite high. Any ideas?

Cheers

Okay got it... Thanks guys :D. Sorry.

AM I using the best graph type to display these sort of stats in your guys opinions?

LOL, you don't sound so sure, so here again I have attached a final version so I would appreciate your feedback.

And thanks for your help so far!