Search
 
 

Display results as :
 


Rechercher Advanced Search

Latest topics
January 2017
MonTueWedThuFriSatSun
      1
2345678
9101112131415
16171819202122
23242526272829
3031     

Calendar Calendar


Create In-cell bar charts in Excel

View previous topic View next topic Go down

Create In-cell bar charts in Excel

Post by ranjithkumar8352 on Thu May 15, 2014 6:41 am

Hello Everyone,

I would like to post 2 simple ways to create In-cell Bar charts which are simple but helps to analyse the data at a glance  Smile

The first way is using Data bars in conditional formatting.

First select the raw data you have then go to home tab > conditional formatting > Data bars > more rules > customize the color of bars here and make sure to tick 'Use data bar only' and its done  Cool 



Second way is using 'Rept' function in excel

First lets understand how Rept function works

The syntax is =REPT(text, numberoftimes)..You understood that right?  cheers  Yes, It just repeats the text the number of times given

Coming into charts we shall use "|" symbol in this function and then use playbill font so that it looks like bar chart in the way as shown in image



Make sure that you use playbill font, because its a bold font with high thickness which makes several  "|" to be joined as one big "|" and looks like a bar chart..

Hope it helped you.

Regards,
Ranjith

ranjithkumar8352

Posts : 5
Join date : 2014-05-14

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum