Hi, i am trying to add the row total for the week on top of the bar chart. I also want to keep the individual data label per the issue type. How can i add the week total at the top of the pivot? image attached of expected result.
Hi, i am trying to add the row total for the week on top of the bar chart. I also want to keep the individual data label per the issue type. How can i add the week total at the top of the pivot? image attached of expected result.
Administrative note
Welcome to the forum
in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?
Please take a moment to read it and attach a sheet accordingly.
Thanks you for helping us help you
Hello,
Yes you are right. Thank you i have attached a sample data set.
Also, do you know how to add a vertical line on the pivot chart, like the one in the sample about "New model launch"? If i manually add it, I will have to shift it every time I add new data to the data set. It would be great to add it as a part of the data somehow so when i update the pivot table with new data, it automatically stays in place.
Following the instructions section labeled "Making Regular Charts from Pivot Tables" (scroll down) in the tutorial linked below I constructed a regular chart (rows 21:35) from the pivot table.
https://peltiertech.com/?s=regular+c...om+pivot+table
Note that the Grand Total for rows is charted as a line with no fill and data labels set to above.
Note that in order for the chart to update along with the pivot table there are VBA instructions in the "Update Regular Chart when Pivot Table Updates" section of the tutorial. As I have no experience with VBA, I didn't include the code in the attached copy of the file.
There would also be an option of adding a column to the source data and having the Total display as part of the X axis label which would not require VBA (not shown).
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks