Ever wanted to highlight maximum value in charts? Then this tip is for you.
Sample data – Highlighting max values in Charts
Let’s say you have some data like this. If you make a chart, you get the output shown to right.
To highlight values, just add extra series
Now the fun part begins. To highlight values in Excel charts, we simply need to add extra series with the values you want to highlight. Let’s say you want to highlight the product with maximum units sold. Add an extra column to calculate the values, as shown below.
Now, our chart becomes this:
But we just want one series, not two!!!
While this highlights max value in a different color, it doesn’t quite cut it. We just need to remove the original value.
Or, we could simply overlap one series on top of another, like layering.
Select the chart series and go to format series (Click on the series, press CTRL+1).
Now, set up series overlap to 100% and your maximum value is highlighted.
That is all. In just a few minutes and clicks, your chart highlights maximum value.
Another example – Line chart with maximum value highlighted
Here is another example of this technique. This time with a line chart.
Apply this idea for other situations too…
You can apply this technique to highlight various kinds of things, like:
- Minimum values
- Above average values
- Values that meet certain target
- User selection values
FREE Download – Sample file for this tip
Click here to download sample file with few types of highlighted charts. Examine the data, formulas and chart settings to learn more.
Highlight maximum value in Excel charts – Video tutorial
More ways to customize Excel charts
This is one of the many powerful but easy techniques for working with Excel charts. Here are a few of my favorite tips on charting. Check them out to learn more.
Add a reference line to charts
Create info-graphics with shape fill options
Forecasting using Excel charts
7 Responses to “Extract data from PDF to Excel – Step by Step Tutorial”
Dear Chandoo,
Thank you very much for this and it is very helpful.
However, all the Credit Card Statements are now password protected.
Please advise how can we have a workaround for that
Hello sir,
How to check two names are present in the same column ?
Thanks and Regards
Hi, Thank you for the great tip. One problem, when I click on get data >> from file, I don't see the PDF source option. How can I add it?
I tried to add it from Quick Access toolbar >>> Data Tab, but again the PDF option is not listed there.
I am using Office 365
Hi, Thank you for your video. I see you used the composite table, but I when I load my pdf, it does not load any composite table. It has 20 tables and 4 pages for one bank statement. I have about 30 bank statements that I want to combine. Your video would work except that I can't get the composite table and each of the tables I do get or the pages does not have all the info. what to do?
Dear Chandoo,
How do we select multiple amount of tables/pages in one PDF and repeat the same for rest of the PDF;s in the same folder and then extract that data only on power query.
Thank you
Hi, Thank you for your video. I see you used the composite table, but I when I load my pdf, it does not load any composite table. It has 20 tables and 4 pages for one bank statement. I have about 30 bank statements that I want to combine. nice share
One bank statement takes up 20 tables and four pages in this document. I need to consolidate roughly thirty different bank statements that I have. Your video would be useful if I could only get the composite table, which I can't for some reason, and each of the tables or pages that I can get is missing some information.