Line graph automatically adding weekend dates
 

How do i stop a line graph from automatically adding weekend dates? I just
want the dates in the data, work days.

Line graph automatically adding weekend dates
 

Hi,

You need to set the x axis to be category rather than date.
Right click the chart and pick chart options. On the axis tab you can set
the axis type to category.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"sara rovang" <sara wrote in message
...
How do i stop a line graph from automatically adding weekend dates? I
just
want the dates in the data, work days.

Line graph automatically adding weekend dates
 

sorry, i should have been more clear, how do i do it in 07? i've been all
over the ribbon and can't find the chart options that 03 had, and right
clicking doesn't give it to me.

"Andy Pope" wrote:

Hi,

You need to set the x axis to be category rather than date.
Right click the chart and pick chart options. On the axis tab you can set
the axis type to category.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"sara rovang" <sara wrote in message
...
How do i stop a line graph from automatically adding weekend dates? I
just
want the dates in the data, work days.

Line graph automatically adding weekend dates
 

For xl2007,

Select chart and then x axis. CTRL+1 to open Format dialog.
Axis Options Axis Type: Text axis

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"sara rovang" wrote in message
...
sorry, i should have been more clear, how do i do it in 07? i've been all
over the ribbon and can't find the chart options that 03 had, and right
clicking doesn't give it to me.

"Andy Pope" wrote:

Hi,

You need to set the x axis to be category rather than date.
Right click the chart and pick chart options. On the axis tab you can set
the axis type to category.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"sara rovang" <sara wrote in message
...
How do i stop a line graph from automatically adding weekend dates? I
just
want the dates in the data, work days.

Line graph automatically adding weekend dates
 

Oh! so i can also just right click the x-axis labels and it shows up, as
opposed to right clicking the actual graph, thanks so much!

"Andy Pope" wrote:

For xl2007,

Select chart and then x axis. CTRL+1 to open Format dialog.
Axis Options Axis Type: Text axis

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"sara rovang" wrote in message
...
sorry, i should have been more clear, how do i do it in 07? i've been all
over the ribbon and can't find the chart options that 03 had, and right
clicking doesn't give it to me.

"Andy Pope" wrote:

Hi,

You need to set the x axis to be category rather than date.
Right click the chart and pick chart options. On the axis tab you can set
the axis type to category.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"sara rovang" <sara wrote in message
...
How do i stop a line graph from automatically adding weekend dates? I
just
want the dates in the data, work days.

Line graph automatically adding weekend dates
 

Sorry but I must be missing something. I'm with you until "Axis Options", but
under "Axis Options" I don't see anything that says "Axis Type" or anything
that gives me the option to have a text axis. Thanks

"Andy Pope" wrote:

For xl2007,

Select chart and then x axis. CTRL+1 to open Format dialog.
Axis Options Axis Type: Text axis

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"sara rovang" wrote in message
...
sorry, i should have been more clear, how do i do it in 07? i've been all
over the ribbon and can't find the chart options that 03 had, and right
clicking doesn't give it to me.

"Andy Pope" wrote:

Hi,

You need to set the x axis to be category rather than date.
Right click the chart and pick chart options. On the axis tab you can set
the axis type to category.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"sara rovang" <sara wrote in message
...
How do i stop a line graph from automatically adding weekend dates? I
just
want the dates in the data, work days.

Line graph automatically adding weekend dates
 

What kind of chart have you created? Is it an XY chart or a line chart? The
descriptions in this thread cover line charts only. If you are using Excel
2003 or earlier, see Andy's earlier post. Andy's latter post id for Excel
2007.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"GR" wrote in message
...
Sorry but I must be missing something. I'm with you until "Axis Options",
but
under "Axis Options" I don't see anything that says "Axis Type" or
anything
that gives me the option to have a text axis. Thanks

"Andy Pope" wrote:

For xl2007,

Select chart and then x axis. CTRL+1 to open Format dialog.
Axis Options Axis Type: Text axis

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"sara rovang" wrote in message
...
sorry, i should have been more clear, how do i do it in 07? i've been
all
over the ribbon and can't find the chart options that 03 had, and right
clicking doesn't give it to me.

"Andy Pope" wrote:

Hi,

You need to set the x axis to be category rather than date.
Right click the chart and pick chart options. On the axis tab you can
set
the axis type to category.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"sara rovang" <sara wrote in message
...
How do i stop a line graph from automatically adding weekend dates?
I
just
want the dates in the data, work days.