Hi All
I have a selection of data that I want to create scatter chart with a smooth line graph for.
They are grouped by account type and day of the week.
I have a total of 15 accounts and 5 working days.
I have looked on google and here in MrExcel and found that I need to create a dynamic chart from a drop down list. But I am not sure how I would alter this to be able to choose as I wish.
Here is an example:
ACT1 sits in A2, and the figures start in c3 to V7 for all days of the week.
ACT2 would start at A9, and ACT3 start at A16 and so on.
ACT 1
Mon -0.5 -1.2 -2.1 -3.7 -2.9 -6.8 -8.2 -6.1 -4.2 -2.1 -3.4 -2.3 -3.5 -4.1
Tues -1.6 -2.4 -3.6 -8.6 -3.6 -4.0 -4.7 -3.7 -4.4 -6.5 -3.1 -2.9 -4.9 -3.9
Weds -1.0 -0.6 -0.9 -1.5 -2.8 -3.5 -10.6 -4.7 -7.7 -9.2 -4.3 -1.9 -2.5 -4.5
Thurs -1.5 -0.2 -0.3 -0.8 -1.7 -5.4 -5.6 -3.8 -3.0 -3.2 -4.7 -4.8 -3.8 -1.7
Fri -1.2 -0.2 -2.3 -2.0 -3.3 -4.7 -5.6 -7.1 -3.1 -2.1 -2.4 -2.6 -4.5 -5.5
Any help would be greatly appreciated. I would rather do this that have a drop down list with Account 1 Monday, Acount1 Tuesday and so on, just to make the list smaller and more manageable.
Hope this makes sense.
Thank you for helping.
I have a selection of data that I want to create scatter chart with a smooth line graph for.
They are grouped by account type and day of the week.
I have a total of 15 accounts and 5 working days.
I have looked on google and here in MrExcel and found that I need to create a dynamic chart from a drop down list. But I am not sure how I would alter this to be able to choose as I wish.
Here is an example:
ACT1 sits in A2, and the figures start in c3 to V7 for all days of the week.
ACT2 would start at A9, and ACT3 start at A16 and so on.
ACT 1
Mon -0.5 -1.2 -2.1 -3.7 -2.9 -6.8 -8.2 -6.1 -4.2 -2.1 -3.4 -2.3 -3.5 -4.1
Tues -1.6 -2.4 -3.6 -8.6 -3.6 -4.0 -4.7 -3.7 -4.4 -6.5 -3.1 -2.9 -4.9 -3.9
Weds -1.0 -0.6 -0.9 -1.5 -2.8 -3.5 -10.6 -4.7 -7.7 -9.2 -4.3 -1.9 -2.5 -4.5
Thurs -1.5 -0.2 -0.3 -0.8 -1.7 -5.4 -5.6 -3.8 -3.0 -3.2 -4.7 -4.8 -3.8 -1.7
Fri -1.2 -0.2 -2.3 -2.0 -3.3 -4.7 -5.6 -7.1 -3.1 -2.1 -2.4 -2.6 -4.5 -5.5
Any help would be greatly appreciated. I would rather do this that have a drop down list with Account 1 Monday, Acount1 Tuesday and so on, just to make the list smaller and more manageable.
Hope this makes sense.
Thank you for helping.
