Updating Values and X Axis Labels

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
 
J

Jon Peltier

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
 
G

Guest

Jon - I do not see an option to set the min and max to auto. Please advise.
Much appreciated - Sony
 
G

Guest

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
 

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

Similar Threads

Date Range for X-Axis Labels 2
Pivot Chart - X-axis labels when adding data 0
X-Axis Labels 1
Axis labels offset from grid line 0
Data labels along below x axis when y axis has negative values 1
Position of X axis labels 4
Data Labels Disappearing 0
Line Chart - Problems with labeling X-Axis 3

Top