Hi I want to add a forecast line onto the pivot chart as shown below. I have the forecasted data, how do I show it into the chart. Also, if it is not possible for my dataset, is it possible to manipulate my dataset to do it.
Sample1.png
Hi I want to add a forecast line onto the pivot chart as shown below. I have the forecasted data, how do I show it into the chart. Also, if it is not possible for my dataset, is it possible to manipulate my dataset to do it.
Sample1.png
Hi Coltan 123,
you have to separate data and forecast into different series.
Then its just a matter of setting how you want them to appear on the graph.
You can choose to display each serie and forecast as a group, or separated, by switching the order of month and product in the pivot table.
Attachment 702353
Attachment 702354
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks