I have a pivot table with the columns: Product, Sum of Profit, Average Profit.
There are thousands of products and I have to show the Top 10 Products sorted by Sum of Profit. Now I want to make a bar chart showing the Average Profit of each of these 10 Products.
But every time I make a chart, it puts the Sum or Profit column into the chart also, and I don't want that data in the chart.
How do I make a chart with just the Product and Average Profit columns?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks