excel -adding new bar chart columns doesn't work

[Lhuffst]

I have an excel spreadsheet that counts statistics of work per type per person each month. We have to add 4 new employees. I added them to the data sheet (separate tab from chart) but on the chart it is only picking up one person. I thought that maybe the width of the bars needed to be reduced so we could fit more on the page. I was able to reduce the gaps but still did not see the last three people.

I changed the legend axis to split the wording into 2 lines to give me more space. No changes on the number of people shown on the horizontal axis.

Actually when I right click and select data, the horizontal axis labels is missing the last 3 people but when I click edit and select the axis labels it does highlight all of the people.....

='Data Entry1'!$A$17:$A$38

I am not sure what to check now and don't really do anything with excel. The person who created this just left for another job so no help there. Can anyone tell me what to check?

Do I have to reselect the data columns as well or just the peoples names show in ='Data Entry1'!$A$17:$A$38.
Thanks
Lhuffst

 

[Lhuffst]

Figured it out. I kept going to the axis label that had the names but didn't check the legend entry series because they were correct. However, that is where I had to change the Series values to include the last 3 people. Thanks anyway!

 

[SkipVought]

Hi,

If you make the [highlight #FCE94F]chart source data table[/highlight], a [highlight #FCE94F]Structured Table[/highlight], you chart will automatically adjust to greater or fewer rows.