Chart, X-axis range

  • Thread starter Thread starter Richard Evans
  • Start date Start date
R

Richard Evans

I'm using Excel 2003. In column A, I have dates from June 1 to
December 31 (6/1 - 12/31). In columns B, C, D I have data for each
date. I create a line graph for the month of June. When I create the
graph, I select the range that includes only the June dates. The dates
form the X-axis of the chart. The dates displayed range from 5/30 to
7/2.

Where are the May and July dates coming from? I've verified that I
selected only June dates. There aren't even any May dates in the
spreadsheet.

Dick Evans
 
Hi Dick
Excel seems to guess that you want to show complete weeks. One simple
solution: change the scaling of the X-Axis to your desired values
 
Frank Kabel said:
Hi Dick
Excel seems to guess that you want to show complete weeks. One simple
solution: change the scaling of the X-Axis to your desired values
Click to expand...

That did it, but brings up another question. I created the chart as a
line chart. In that form, the scale showed up as formatted dates. I
changed the chart type to scattergram, and the scale shows as the
decimal equivalent of dates, making it difficult to specify dates as
min/max values. Why did the scale change format? How can I get it back
to something more meaningful?

Dick
 
Frank Kabel said:
Hi
you can apply a format like MMM-YY to your axis
Click to expand...

The axis is formatted as "Date" and displays correctly. The problem is
in the Scale tab, which shows the min/max values as decimal values
instead of the date. Makes it hard to specify a start/stop range.
Quick, what's the decimal value for August 14, 2004?

When I created the chart the Scale tab displayed in date format.
Simply changing the chart style caused the Scale tab to display (in
the min/max fields, not the axis itself) decimal equivalents instead
of dates. I want the Scale tab to display dates.

Dick
 
Hi
I've never seen this behaviour before. Have you tried creating your
chart from scratch?
 
Frank Kabel said:
Hi
I've never seen this behaviour before. Have you tried creating your
chart from scratch?
Click to expand...

Depends on what you mean "from scratch." I created it with "Insert >
Chart." Is there another way?

Dick
 
Back
Top