Chart X Axis value label on both left and right sides

B

Beemer

Can I add a second X axis value on both left and right sides of a chart?
At present scrolling the chart to the right there are no axis label
values to easily read the chart.

Beemer
 
B

Bernie Deitrick

Beemer,

You have to have at least two Data Series to do that. Right click on the
second of them, choose Format Data Series, then on the Axis tab, choose
secondary axis. Note that Excel may change the relative values between the
first and second axes, so you should set the Max and Min for both manually.

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top