You must have surely created bar charts from your data to have a better representation of it and take decisions/actions accordingly.
Now, instead of creating a bar chart somewhere outside, how about you create the chart within your data?!
Confused?! Read along…
Select you data which you want to see in the chart.
Then go to the Home tab and go to Conditional Formatting.
Under Conditional formatting, select Data Bars, and choose the colour you like the most 😉
This is what you will see (image below, example)..
The largest number will have the longest bar, and relative to that, the length of other bars will be adjusted and shown.
Thus, you don’t need to create a separate chart outside the data.