Passa al contingut principal

Bubble Heat Chart

Garden City Consultants

2.3 (3)

A tool to visualize up to 4 dimension data into a bubble heat color chart.

Description:

Bubble Heat Chart Excel add-in is a tool to visualize up to 4 data series by using axis X, Y, bubble color and size.

There are 2 types of bubble chart in this add-in:

  • Color Category Bubble Chart: the color represents the category of the data.

  • Color Heat Bubble Chart: the color is turned into heat-map to represent the numeric value.

There are 3 sample data in this add-in to show the usages of the bubble chart:

  • Color Category Bubble Chart

  • Housing, GDP, Population by States

  • Security Risk Return Chart

  • Color Heat Bubble Chart

  • Housing, GDP, Min Wage, Population by States

The data are in 5 columns in the following order:

  • Name(ID) of the data

  • Numeric value for the axis X

  • Numeric value for the axis Y

  • In Color Category Bubble Chart, the 4th column has string value to represent the group, category of the data.

  • In Color Heat Bubble Chart, the 4th column has the numeric value that can be rendered into heat-map color for the bubble.

  • Numeric value for the size of bubbles.

Features:

  • Visualize up to 4 data series.

  • Easy to use and user friendly. Sample data can be the template to build own data.

  • Change the title by clicking the title area and enter the text as needed.

  • Mouse over the bubbles to view the detail in the tool-tips.

  • Interactive Chart: the chart is binding to the data table in the sheet, the chart is drawing when the data is entered.

Instruction:

  • Download this add in and start Excel 2013 SP1 or later.

  • Select a sample data in the settings screen.

  • Click Insert Sample Data button to insert the sample data and view the chart.

  • Delete the data in the sheet and repeat step 2, 3 to view different type of chart.

  • PPaste own data into the sample data table and click binding the existing table button to draw the chart

  • Change colors in Settings screen as needed.

  • Click in the title area in chart to enter desired title.

Version 1.0.0.1 Release Notes:

New features:

  • Merge the ChartType and Sample Data setting to simplify the settings.

  • Add Video Tutorial.
Capacitats del complement
Quan s'utilitza aquest complement:
  • Pot llegir el document i fer-hi canvis.
  • Pot enviar dades per Internet.
  • https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949680048/Asset_89abc3ce-9fcc-4c63-a69c-09b05194333c/BubbleChartScreen1.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949680048/Asset_89abc3ce-9fcc-4c63-a69c-09b05194333c/BubbleChartScreen1.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949680048/Asset_03e7f4f5-728d-447a-a9dd-cd7ca5a9bc12/BubbleChartScreen0.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949680048/Asset_4a36fcd7-3669-4202-b603-5d5e3fc50002/BubbleChartScreen2.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949680048/Asset_9a1e1b28-3ea4-4789-b3a6-c9b1499703be/BubbleChartScreen3.png