How to do Conditional Formatting of Charts in PowerPoint

When creating a report, sometimes you want your client to pay attention to specific numbers which matter more. Therefore, to emphasize certain values, columns, or rows on your charts, you may need to use a conditional formatting function. If you are using Microsoft PowerPoint, you probably know that you should do it in Excel in advance and copy-paste the chart into the PowerPoint presentation. Unfortunately, this process is quite time-consuming and issue-oriented and works only if you paste the charts from Excel as a picture.

To make this process more painless Chartrics Chart Maker allows you to conditionally format your charts right in PowerPoint, created from raw data and Excel Workbook.

 

Method

  1. In Chart Maker, click on Conditional Formatting button
  2. In Format dialog box click on New Rule button
  3. Under Apply to > select one of the available options > select Category > select the Condition > set the Value > Choose Number Color or Cell Background Color > Apply

Automatically update all your PowerPoint charts with the new data in 15 seconds.