Charting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an excel spreadsheet that contains 52 weeks of data. I want to just
chart the weekdays not the weekends. How do I get the source data to be just
that?
 
One thought would be to do the following:

1) Enter a helper column in your table of data in which you determine
if the day in question is a weekday or weekend. Assuming your dates
are in column A, then a formula like
=IF(OR(TEXT(A1,"ddd")="Sat",TEXT(A1,"ddd")="Sun"),"Exclude","")

2) Use the pivot table tool to create a pivot table in which you
filter the data to exclude the "exclude" records

3) Build a pivot chart off that pivot table.

There may be a simpler way than this.

Dave
 
Your table has weekday data and not weekend data, right? Make the chart.
Excel recognizes the dates and creates a time scale axis, which includes all
seven days per week. Go to Chart menu > Chart Options > Axes tab, and change
the Category (X) Axis option to Category. This now gives you categories only
where you have actual data, without gaps on weekends and holidays.

- Jon
 
Back
Top