Chart X Axis value label on both left and right sides

  • Thread starter Thread starter Beemer
  • Start date Start date
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
 
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
 
Back
Top