Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hi,
I am creating a chart that has week day information only, but when the chart is formed, the weekends are included. Is there a way to exclude the weekends? There is no weekend information in the chart data area. Thank you, Janel |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hi,
In order to exclude dates that do not have data you can set the axis to be categorical. This will plot a point for each date which will be equally spaced. Right click chart and pick Chart Options from the context menu. On the scale tab set the axis type to category. Cheers Andy Janel wrote: Hi, I am creating a chart that has week day information only, but when the chart is formed, the weekends are included. Is there a way to exclude the weekends? There is no weekend information in the chart data area. Thank you, Janel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
dates problem | Excel Discussion (Misc queries) | |||
Dates Problem | Excel Discussion (Misc queries) | |||
How do I get the dates on an excel chart to stay as dates instead. | Charts and Charting in Excel | |||
Problem Dates | Excel Discussion (Misc queries) | |||
Problem with dates | Excel Worksheet Functions |