5 Excel features to create data-dependent visualizations

There are several useful features in Excel that can help to create your charts, which automatically change visual appearance depending on data.

    1.    Label changes

The simplest way to add interactivity to your charts is to use some cell value instead of a static text for the label. Also, you can make the chart more appealing by adding fancy images:

The Competition Chart Excel 2016
The Competition Chart Excel 2013

See Creating a simple competition chart in Excel 2016 and Creating a simple competition chart in Excel 2013 for more details.

    2.    Automatic data range updates

If you are adding data frequently, and, thus, each time need to adjust your data ranges so that your charts plot an updated data range, you may be interested in the trick that forces Excel to update the chart's data range whenever you add a new data to your worksheet:

The Chart  in Excel 2013
The Chart with automatically extended plot ranges in Excel 2013

See Creating automatically extended plot ranges for more details.

    3.    Title depending on volume

For some presentations will be interesting to add title that contains automatically updated data, for example, a text dependent on volume:

Changeable Title Chart Excel 2016
Changeable Title Chart Excel 2013

See How to create dependent on a volume chart title in Excel 2016 and How to create dependent on a volume chart title in Excel 2013 for more details.

    4.    Dynamically updated label text

For some presentation of the competition will be more informative to see dynamically updated chart labels that depend on value or other cells:

The Chart with labels Excel 2016
The Chart with labels Excel 2013

See Creating a chart with dynamic labels in Excel 2016 and Creating a chart with dynamic labels in Excel 2013 for more details.

    5.    Chart visual appearance depending on:

    a.    volume:

Data visualization is a key cognitive tool that enables you to attract the attention to your statements. E.g., you can direct your organization attention to insufficiently developed goals and praise them for successfully performed goals:

The thermometer Chart Excel 2013

See Creating a semaphore thermometer chart for more details.

    b.    data:

To emphasize differences between data in the chart it will be interesting to create a column chart in which the color of each column depends on the value displayed:

Colored column chart in Excel 2013

See Displaying conditional colors in a column chart for more details.

Thank you for visiting OfficeToolTips

We are glad to help you in your work. However, you are using ad blocker and our efforts will not be rewarded.

Please consider disabling ad blocker before continuing the reading.