Excel Charts: Customize Data Table

[CHBC1]

Hello,

I'm admittedly not an expert when it comes to excel charts. What I have here is a small data set comparing average fees per account for four different mutual funds. I have that charted off to the right, but in the data table below, I just want to show the % change. I'm just trying to find a clean way to chart all this data. If it's not possible to customize the data table, the only other alternative option I can think of is to just keep it as is, then delete my data labels to avoid redundancy. Not a terrible option, but I figured I could check to see if anyone has heard of how to customize the data charts to show only some of your data set, not all.

Thanks in advance!

(Please ignore the black boxes..I intentionally censored part of my screenshot for confidentiality purposes)

 

[Steve=True]

Hi CHCC1,

Unfortunately, Excel Data Tables are not very customizable.

You can add data like these tutorial, but not sure how you can take away data in the same chart.

how-to-fake-an-excel-chart-data-table

how-to-show-text-in-an-excel-chart-data-table-part-1

how-to-add-a-line-to-an-excel-chart-data-table-and-not-to-the-excel-graph

Alternately, you can position your chart above your worksheet and put in your % in a quasi data table. Then it looks like it is part of the chart, but not really.

Hope this helps.

Steve=True

 

[CHBC1]

Hi CHCC1,

Unfortunately, Excel Data Tables are not very customizable.

You can add data like these tutorial, but not sure how you can take away data in the same chart.

how-to-fake-an-excel-chart-data-table

how-to-show-text-in-an-excel-chart-data-table-part-1

how-to-add-a-line-to-an-excel-chart-data-table-and-not-to-the-excel-graph

Alternately, you can position your chart above your worksheet and put in your % in a quasi data table. Then it looks like it is part of the chart, but not really.

Hope this helps.

Steve=True

Ah yes very true. I like the idea of using a "fake" data table.

Thanks for the idea!