format a column to show bars

L

light_wt

Hi,
A presenter showed us a feature in Excel that convert a column of numbers
into number with bars under it. how is it done?

i.e. say column B has the following:
23
214
33
236

then the 236 will have somehting like a 2D bar chart under it being the
longest and 23 will have the shortest.

thanks.
 
L

light_wt

thanks for the quick reply.

It is the Data Bars in Conditional Formatting.

thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top