?? Not a single reply
if there are multiple data items on a pivot table, is it possible to have a individual graph for each item.?
I got a pivot table with following details
Row Values: Dept_Code, Super_group, Product_Group
Column Values: Ending_Date
Data: Sales, Availability%, Waste%, Number of Stores
i need to have a bar chart with trend line individually on each data items e.g.Sales, Availability% etc.
when i tried to use trend line it prompts me to enter series i.e Ending_Date and it draws trend line for only that period comparing all data values.
is there any way to have individual graph for Sales, Availability%, Waste%, Number of Stores with trend line covering
Any help will be much appreciated
I doubt you can have multiple pivot charts based on a single pivot table as the changes in the chart are automatically reflected in the table.
You would need multiple tables in order to have multiple charts.
Or create normal charts instead of pivot charts.
There are currently 1 users browsing this thread. (0 members and 1 guests)