![]() ![]() Right click at the Sum of Profit series, and select Format Data Series from the context menu. Now I am talking about adding a secondary axis to a pivot chart in Excel to solve this problem.įor instance, I want to add a secondary axis to show Legend series of Sum of Profit.ġ. A pivot chart can help us to quickly analyze base data, but sometimes, if there is a great values’ difference between the series, the chart will be shown not beautiful and exact enough as below screenshot shown.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |