Charting
 

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?

Charting
 

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

On Aug 1, 10:40 am, par3 wrote:
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?

Charting
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"par3" wrote in message
...
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?