Bubble Line Chart Template in Excel - Excel Tips and Tricks

Learn how to make bubble line chart template in Excel.

Creating a Bubble Chart in Excel is a straightforward process that begins with selecting the data range, including three sets of values: the x-axis values, y-axis values, and the size of the bubbles. To make a Bubble Chart with quadrants in Excel, additional steps involve adding horizontal and vertical lines to divide the chart into four sections, typically by setting the minimum and maximum values for both axes.

Here are the steps outline on the video.

Insert Chart
1) Ctrl+A
2) Insert ~ Charts ~ Line Chart with Markers
3) Resize and reposition

Markers
1) Right-click marker
2) Format Data Series...
3) Fill & Line
4) Marker
5) Marker Option
6) Built-in
7) Type = circle
8) Size = 40
9) Fill = Solid fill
Color = Light blue
10) Border = Solid line
Color = Dark blue

Data Label
1) Right-click marker
2) Add Data Labels
3) Select Data Label
4) Label Option
5) Label Position = Center
6) Number, Category = Custom
7) Format code as [