Updating Values and X Axis Labels

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Thanks for your help. This response by XP wasn't expected. When ever I
update the chart value range and X axis labels the chart (line graph) doesn't
update. I click and drag to update the Value and Categoty X axis labels.
Do I have the axsis formated incorrectly? Under the format labels, Right now
I have "base unit" checked. And the Max and Min dates are entered. In
previous versions of excel I know you could just update the cell range and
the chart would update. This should be so elementary. Thanks - Tom
 
If the min and max are not set to auto, the added data may be outside the
range of the axis, and you can't see it.

- Jon
 
Jon - I do not see an option to set the min and max to auto. Please advise.
Much appreciated - Sony
 
In the Format Axis Dialog Box, go to the Scale tab. You should see
checkboxes for "Auto" along the far left side of the box.

You can get to the Format Axis Dialog Box by double-clicking on any of the
Y-Axis data labels.

--
John Mansfield
http://cellmatrix.net
 
Back
Top