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
 
Top