![]() |
Chart problem with dates
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 |
Chart problem with dates
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 |
All times are GMT +1. The time now is 10:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com