M
Mas
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
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