Charts not recognizing label column. Chart values appear to be fine.

Hello,

I apologize if this has come up, I was unable to find a relevant post.

I currently have a data set with Dollar Values in Column E, an internal reason code in Column F and an additional reason code in Column G.

Amount DeletionReason DeletionReason2
60 Customer Removing Hardware Decommissioned Hardware
88 Customer Removing Hardware Decommissioned Hardware
105 Customer Removing Hardware Cloud
4874 Customer Replacing Hardware Equipment Refresh
11 Customer Removing Hardware Decommissioned Hardware
81 Customer Removing Hardware Decommissioned Hardware
28 Customer Keeping Hardware Reduction In Service Level

Excel creates a recommended graph from Columns E&F summing up the amount by deletion reason with no issues. It will not do this when selecting Column E and G though. I know there are other options to complete this, but end users have brought this question up to me and I have been unable as of yet to find an explanation.

Any help would be greatly appreciated.

Hi,

In order to try and help you are you able to attach a copy of your file so we can take a look ?

Regards

peterrc