Here’s everything you better know about how to do it.
Here’s what our chart will look like after running through the steps in this article.
Step 1: Prepare Your Data
Start by creating your Excel table.
Lucas Gouveia / How-To Geek |Kaspars Grinvalds/ Shutterstock
Then, choose a design that works for you.
As you’re able to see, we’ve chosen a simple green design.
Step 2: Create Your Chart
Now, you could create the chart for your table.
Select all the data in your table (including the header row).
For our data, we’ve chosen a 2D clustered bar chart.
In our example, we want to highlight the three largest values.
Now, specify how many values you want to extract.
After you have typed your formula, press Enter.
If the cell remains blank, it means that it’s not one of the three highest values.
snag the chart, open “Chart Design” on the ribbon, and click “Select Data.”
In the Edit Series window, you will see two fields to complete.
First, clear both fields of any information they already contain.
In our case, we would highlight cells C2 to C8.
Then, hit the Series Name field box and go for the table header for the new data range.
In our case, we would select cell C1 (Largest 3).
You will now see the final outcomeyour chart highlights the max three values in your Excel chart!
First, you should probably check that your chart includes data that is contained within hidden cells.
Here’s our finished product!
