Grouping data Charts

[just08in]

I have a data to be charted out.

The data is like

Activity A

Scope

Total Achieved

Activity B

Scope

Total Achieved

Activity C

Scope

Total Achieved.

Now the above data I have for 4 weeks


Now I need a chart in which I show in X-axis the

Scope/Total Achieved - for all weeks under Activities.


So the grouping of data happens by week first and then by Activities. How can that be done in excel

 

[Hui]

Just08in

Have you tried using a Pivot Table/Chart?


Can you upload a sample of data to allow us to assist?

 

[Montrey]

Use a bar chart. This will group each activity