Chart help in excel

[Poweruser99]

I am trying to construct an analytical graph. Below is sample data

Name Monday Tuesday Wednesday Total
-------------------------------------------------
ABC 2 2 2 6
EFG 5 5 5 15

I am trying to make a Bar chart for each name. The chart for ABC should have graphed 6, and within that line graph the 6 should be broked up into each days.

Please let me know if someone can assist me.

 

[SkipVought]

Hi,

Filter the table that is your source data.

Select one Name at a time.

If you chart does not change with each selection...

Select the chart, Tools/Options - Chart Tab and select the plot visible cells option

Skip,

_[red][/red]