Search
 
 

Display results as :
 


Rechercher Advanced Search

Latest topics
July 2017
MonTueWedThuFriSatSun
     12
3456789
10111213141516
17181920212223
24252627282930
31      

Calendar Calendar

Keywords


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
avatar
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