How to display the items inside the chart correctly?

[daliye]

Hi,
This is the format of the data the pivot table I created, and the pivot chart I created.
I want to display the years' values inside the chart, how to do so?
I want to be shown as years being compared to each other in a line chart format.
What I learned for pivot tables that it should be one column for years and this is what I did, but why inside the pivot table it is not showing correctly?
The empty cells inside the pivot table under years columns are shown as zeros inside the chart, why?
How to adjust the chart?
Where is the missing part to correct it?

[Glenn Kennedy]

I'm not really clear what you expect to see. How is this for a starter?

Please Login or Register  to view this content.

[daliye]

Thanks a lot for your reply.
I am sorry for my late reply.
My problem is that values for years are not in the same column, so each year has values in a different column, and that lets the chart show zeros when displaying the results.
What I would like to show in the chart is that each year has its value and no zeros, I mean as if all years are in one single column.
But if all years are shown in a single column, that way I can do the comparison as fine.
I hope you can solve it.
I am sorry once again for the late feed back.

[Glenn Kennedy]

I cannot edit a picture of an excel sheet. You should know that by now...

[romperstomper]

If you want to compare years, you can't include the full date in the pivot since that also includes the year. You'll also probably want markers on the lines since you have gaps in your data.