ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Chart problem with dates (https://www.excelbanter.com/charts-charting-excel/134855-chart-problem-dates.html)

Janel

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

Andy Pope

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