Graphing by days of the week

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mas - 31 Aug 2006 21:54 GMT

Hi all,

I would like to create an individual graph for each individual day of
the week for a complete month. What I have is two columns, column A
consists of the date (i.e. 1-May) and column B consists of a number.

I would like to graph every Monday of a month on a separate graph to a
Tuesday and graph Tuesday on a separate graph than a Wednesday.

How would I go about getting Excel to work out which date equals which
day and then graph it?

Example:

Column A Column B
1-May 5
2-May 10
3-May 15
8-May 10
9-May 10

Monday graph would consist of 1-May and 8-May with a line graph at 5 and
10.

Hope that this is clear and understandable.

Thank you for your help in advance.

Mas

Reply to this Message

Debra Dalgleish - 01 Sep 2006 02:03 GMT

You could create a chart from all the data in columns A and B
Then, in column C, add a formula to show the weekday. For example, in
cell C2:

=TEXT(A2,"ddd")

Copy that formula down to the last row of data.

Select the chart, and choose Chart>Chart Options
On the Axes tab, under Category (X) Axis, select Category
Click OK

With the chart still selected, choose Format>Selected Chart Area
On the Properties tab, choose Move but don't size with cells
Click OK

Select a cell in the table of data, and choose Data>Filter>AutoFilter
From the dropdown list in cell C1, choose a weekday
The chart will show only that weekday's data.

To show the weekday in the chart title, in cell E1, enter the formula:

=TEXT(SUBTOTAL(4,A:A),"dddd")

Select the chart title, and type an equal sign
Click on cell E1, then press Enter

> Hi all,
>
[quoted text clipped - 25 lines]
>
> Mas

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message