![]() When I go to change the chart to show just what I wish to view, it both changes the chart and also formats the pivot table to match. However at the moment, when I create the charts, excel makes a Pivot Chart, which shows all of the data in that pivot table, rather than the specific data which I wish to show. ![]() In each of the charts, it would show different data. What I am trying to achieve is to use one pivot table which I have, and create multiple charts from the one table. Once I change the chart by using the inbuilt filters within the chart, it automatically changes the table too. Yeah in some ways, however its the chart which is filtering the table, not me.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |