**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.*