Excel - General Question on Pivot Table - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I have a problem on creating a bubble chart from a pivot table.
Solved by V. Y. in 22 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 07/06/2018 - 07:48
Hi
User 07/06/2018 - 07:48
hi
Excelchat Expert 07/06/2018 - 07:48
how are you doing?
Excelchat Expert 07/06/2018 - 07:48
can you provide me the excel you are working on?
User 07/06/2018 - 07:48
fine thanks
User 07/06/2018 - 07:48
not really
User 07/06/2018 - 07:48
sorry
User 07/06/2018 - 07:49
but if you can help with the descriptions that I give you Id be thankful
Excelchat Expert 07/06/2018 - 07:49
oh ok..
User 07/06/2018 - 07:49
so I have this file which has 15000 rows and quite many columns and there will be data added to it monthly
User 07/06/2018 - 07:50
and I need to create a bubble chart for some of the columns
User 07/06/2018 - 07:50
but I need to create the chart in such a way that I do not have to recreate it every month
User 07/06/2018 - 07:50
but it will be updated as data updates
User 07/06/2018 - 07:50
and I seem to not be able to do that with a pivot table
Excelchat Expert 07/06/2018 - 07:50
hmm
Excelchat Expert 07/06/2018 - 07:50
so you have a pivot table already
User 07/06/2018 - 07:51
yes
Excelchat Expert 07/06/2018 - 07:51
i know you can not provide the data .. but can you provide the columns in your raw data and in you rpivot
Excelchat Expert 07/06/2018 - 07:53
Do you need bubble chart only wont Line graph serve the purpose?
Excelchat Expert 07/06/2018 - 07:55
Hello you there
User 07/06/2018 - 07:55
yes it s just bubble
User 07/06/2018 - 07:55
no other type
Excelchat Expert 07/06/2018 - 07:56
hmm then you have 3 options
User 07/06/2018 - 07:56
tell me
Excelchat Expert 07/06/2018 - 07:56
1:You only need the values from the pivot table,ake a copy of the pivot table, but paste only the values. Now you can make a bubble chart.
Excelchat Expert 07/06/2018 - 07:56
Make a copy of the pivot table, but paste only the values. Now you can make a bubble chart.
Excelchat Expert 07/06/2018 - 07:56
but this means you would have to do the copy paste regularly
Excelchat Expert 07/06/2018 - 07:57
2: The pivot table values may change, but the dimension would stay the same. make a copy of the pivot table, but put in each cell a reference to the corresponding cell (e.g. =E15 ) in the original pivot table. Now you can make a bubble chart.
Excelchat Expert 07/06/2018 - 07:58
In this way you can keep the dynamic data
Excelchat Expert 07/06/2018 - 07:58
or you must choose pivot charts instead if you are ok with it..
User 07/06/2018 - 07:59
how can i mace a copy of the pivot with only the values and refering to cells
User 07/06/2018 - 07:59
like E15 that u mentioned
Excelchat Expert 07/06/2018 - 08:00
so if you pivot table is from a2-e5 for example
Excelchat Expert 07/06/2018 - 08:00
create a new sheet
Excelchat Expert 07/06/2018 - 08:01
In the new sheet in cell A2 type ='Pivot'!A2
Excelchat Expert 07/06/2018 - 08:01
where Pivot is the name of the sheet
Excelchat Expert 07/06/2018 - 08:01
similarly A3='Pivot'!A3
Excelchat Expert 07/06/2018 - 08:01
and so on..
Excelchat Expert 07/06/2018 - 08:02
then it would just be a table and you would be allowed to create the bubble chart
User 07/06/2018 - 08:02
name of the sheet we just created?
Excelchat Expert 07/06/2018 - 08:02
Could be anything..
Excelchat Expert 07/06/2018 - 08:02
Pivot is the name of the sheet where you have pivot table
Excelchat Expert 07/06/2018 - 08:04
See sheet 2 A2 is equal to Sheet1 A2
Excelchat Expert 07/06/2018 - 08:04
can you see
User 07/06/2018 - 08:06
kind of
User 07/06/2018 - 08:06
let me try
Excelchat Expert 07/06/2018 - 08:07
sure.. this is the only work around..excel prevents bubble chart on pivot tables right
User 07/06/2018 - 08:07
yeah
Excelchat Expert 07/06/2018 - 08:08
after doing the 1st cell just drag it it will fill the rest..
Excelchat Expert 07/06/2018 - 08:08
does this help you?
User 07/06/2018 - 08:10
thanks will try
User 07/06/2018 - 08:10
it
User 07/06/2018 - 08:10
gotta go now

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.