CODEWITHSUNDEEP
excelexcel-2010bar-chartpivot-table
Jeebwise
Jeebwise

Reputation: 177

Replace (mask?) numeric axis labels with custom text

In Excel 2010, I would like to replace labels on one axis with custom words. In this case I have several columns and the ID in the database is 7, 17, 27, 34, 41, 48. I created a pivot chart that counts how many times these IDs show up but under each column the labels are these numbers. I would like, for example, 7 to show Application Gap.

I have been goggling like a madman but I can't seem to find the terms I need to get the answer I need.

Is it possible to replace these IDs with the words they actually represent?

Upvotes: 1

Views: 555

Answers (1)

pnuts
pnuts

Reputation: 59485

Yes (based on Excel 2007!) by changing the row labels in the associated PT.

Upvotes: 1

Related Questions