Dear Pivot Experts,
I would like to create a pivot chart for monthly sales and year-to-date (cumulative) sales in one chart. I can't figure out how to get the pivot table. (see the outcome I want to achieve in the attached file).
Hope you could guide me through.
Thank you very much.
May be changing chart type as you have combo Chart.
Select the chart and to design in navigation tab change chart type at the end you will get combo chart ....Sales -Clustered Column and Cummulative -Line and heck mark on Secondary axis
Check the attached file.
This should help.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Hello,
See attached. Add the Sales series again and set the value as the current total in Month.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks