Bubble Chart?

[sungen99]

Could someone give me an idea of how i could recreate this wonderful chart?

[Keebellah]

Probably some extended graph in Office 365 my guess: GOOGLE and chart types Excel

[alansidman]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[MrShorty]

It mostly looks to me like a basic bubble chart. Are you familiar with creating bubble charts (https://support.office.com/en-us/art...1-c766f3e330d9 )?

As with a lot of charting questions, much of the work is getting the data in the spreadsheet. I would expect one column (x value column) with the week number, a second column (y value column) with the year, and a third column (size or z values column) that represents the "size" of the bubble. Create the chart from those three columns, then add formatting and data labels as desired.

Is there a specific part of creating this bubble chart that you are unsure how to do?

[sungen99]

Attached is the example of what I am trying to accomplish. I am trying to replicate the image that is attached.

As far as the start in my example the SIZE of the bubble is determined by C, but I want the VALUE to show from col D. Also- as in the example is there as way for gradation to be automated like a
conditional format? That would really be amazing if that could be accomplished.

Thank you for your help.

K

[MrShorty]

the SIZE of the bubble is determined by C, but I want the VALUE to show from col D.

I assume you are talking about the data labels here, but your sample chart did not include any data labels. To add data labels to the chart, follow the instructions here: https://support.office.com/en-us/art...2-f467c9f4eb2d To get the values in column D to be used in the data labels, follow the instructions under "Use cell values as data labels" after adding the data labels to the chart.

is there as way for gradation to be automated like a conditional format?

Conditional formatting of chart points is usually done with a technique like this: https://peltiertech.com/conditional-...-excel-charts/ The basic idea is to create separate columns/data series for each "gradation" that you want.

[sungen99]

i was really hoping to be able to do conditional formatting like you can with a croup of data. What would be amazing would be able to make a bar1 the color of A1, and bar2 to be the color of A2 and so on.

[sungen99]

i found this will do it.....

https://www.get-digital-help.com/201...on-cell-color/