Note II: when I right click on the pivot chart and click “Select Data.”, I can't remove any legend entries (series), which in this case are the companies (of which I'd like to remove some). The data entries are the yearly revenues of the corresponding companies. The final choice in the dropdown is Include Filtered Items in Totals. With one cell in the pivot table selected, go to the Design tab in the Ribbon and open the Subtotals dropdown. Note I: the graph is a pivot chart, which is based on a pivot table with the years as the row labels and the companies as the column labels. Use the dropdown in A3 to select Value Filters, Top 10, and ask for the top five customers. I wonder how I can automatically depict those companies in the chart that are in this top 10, and that only the legend items for these companies are shown on the side. I therefore wish to include only the top 10 of companies in the graph, where the position of the company in the list is determined by the total revenue of the respective company throughout all of the years. I think it's too cluttered, especially towards the bottom of the page. This is a graph of revenues of different pharmaceutical companies throughout the years. The following image provides an example of what is not going entirely according to plan: I'm currently working with pivot charts in Excel for the first time and I'm having a bit of trouble with it.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |