Need to add budget value in the monthly expense Pivot Chart

[Sivahari]

Hi Friends,

Have a great day ahead!

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

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

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.

 

[Sivahari]

Hi Friends,

Have a great day ahead!

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

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

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.

 

[Sivahari]

Hoping that I will get suitable response from our forum members.

Thanks