Question

How can I relabel a graph or pie chart in excel 2010 so that it has the name of the color of the data(color of specific car sold) instead of the numbers(1,2,3etc) It is a graph and pie chart that is associated with the formulas in the cells and the numbers associated with it.

Answer 1

Right-click on the chart and select "basic data".There choose tab "row" and in the the bottom line select the range of color names which need for a diagram legend.