| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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. |
|
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding a slope line to a graph | Excel Discussion (Misc queries) | |||
| Adding Horizontal line to a graph | Excel Discussion (Misc queries) | |||
| Automatically adding Vertical lines after certain points in line graph | Charts and Charting in Excel | |||
| Adding a line on graph | Excel Discussion (Misc queries) | |||
| adding another axes with line graph | Charts and Charting in Excel | |||
Linear Mode
