Sales vs Shipment Charts with varible weekends

[timschaeffer]

Hello,
I have a sales vs shipments chart that I use in my dashboard. However we have variable weekends. Some Saturdays and some Sundays we may shipment something or we may book an order or two. These days tend to show up as zeros and mess with my trend lines lines and chart. I use a pivot table to generate the data, is there a way to have the pivot table always take whatever happened on a Saturday and Sunday and add it to Monday (or Friday)? So my chart does not show these dips on weekends? I suppose I can change the chart to just look at weeks, not days, but I like the granularity of the days.


Thanks,
Tim

[timschaeffer]

Maybe I just need to force '0' for the Saturday and Sundays and deal with that??

[JeteMc]

What about adding a Chart Date column to the source data, populated using the following:

Please Login or Register  to view this content.

The pivot table would have the Chart Date in the Rows area and the Orders and Shipments in the Values area.
The pivot chart would not have dips, however it would also only show dates that appear in the pivot table.
Let us know if you have any questions.