Need to add budget value in the monthly expense Pivot Chart

Hi Friends,

Have a great day ahead!

I could not able find out the right thread in excel forum as well as in other web pages. Hence, I'm posting my questions in a fresh thread.


I have a excel table where I have to enter the daily/occasional expenses and I will have to consolidate these expense details by yearly and monthly basis using Excel Pivot Table option.

Also, I need to create a stacked column type Pivot Chart and the monthly values shall be stacked as per attached sample picture.

Now, I would like to add the Total Budget / Target Value / Maximum Value in the same excel Pivot Chart using "Line chart type" as per attached sample picture.

I will have to enter the expense details in the excel table only and the associated Pivot Table and Pivot Chart shall be automatically updated.

Please share with your valuable idea to sort out my issues.

Advance thanks for all.

Pict-1.JPG
Pict-2.JPG

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Hi,

The sample work book is attached which contains two sheets namely Actual and Sample.

The required details have been typed manually in the Sample Sheet.

Hi,

Have a good day

Expecting Response/solutions from our Experts/forum users in order to solve my issues.

Thanks.

I found the same questions in our forum but I couldn't find the solutions from it.

Hoping for Response/solutions from our Experts/forum users in order to solve my issues.

The following errors occurred with your submission
You are not allowed to post any kinds of links, images or videos until you post a few times.

/excel-charting-and-pivots/1131679-how-to-add-target-line-to-a-stacked-column-pivot-chart.html
/excel-charting-and-pivots/543796-how-do-i-add-a-goal-line-to-a-stacked-bar-chart-in-excel.html

Thanks

Hoping for Response/solutions from our Experts/forum users in order to solve my issues.