Add pivot row totals to top of bar chart

[excelingtoexcel]

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.

[Pepe Le Mokko]

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

[excelingtoexcel]

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.

[JeteMc]

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.