excel barchart

[CLOUD_xander]

this is the information i need to fixthe barchart  does not show the information in the workbook as displayed 

instead shows me something different

[#2]

@CLOUD_xander 

The source range for the chart is not correct. For one thing, it looks like you included the COLUMN TOTAL and GRAND TOTAL rows, as well as the TOTAL(PERIOD) column. Those should not be included.

And the year column is part of the data, instead of providing the x-axis values.

You can explicitly edit all this by clicking anywhere in the chart, then clicking Select Data on the Chart Design tab of the ribbon.

If you find that difficult, could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Alternatively, you can attach it to a private message to me. Thanks in advance.

[#3 · Accepted solution]

@CLOUD_xander 

I have attached a workbook with two versions of a column chart. See if one of them does what you want.

I changed the layout of the worksheet to work better for charts, mainly by doing away with the merged cells - they wreak havoc with many features of Excel.

[#4]

THX FOR YOUR HELP

[#5]

WE SHOULD CHAT SOME MORE