How to create graphs in excel easily using Conditional Formatting

120 views · Published 5 July 2018 · 12:23 · Indexed 11 October 2026

Channel: Krishna S · 2018 · Science & Technology

Watch on YouTube

Krishtalk.com

With simple conditional formatting you can create a beautiful chart, graph. You can create heat map, line graph, bar graph etc. The solid graph will have bar with one solid colour though out. While gradient type smooth dissolved one end. 

To create a bar graph sleclet the entire area on which you want to create graph, go to conditional formatting and select type of formatting you wnat, then choose gradient in the second drop down. Select the Color you want. Select the border as you wish. Click ok 


Subscribe to my channel:
http://www.youtube.com/user/krishnayess?sub_confirmation=1
YouTube Channel: https://www.youtube.com/krishnayess
My Blog: krishtalk.com
Google Plus: https://plus.google.com/+KrishSanj/
Twitter @iTwittt
https://twitter.com/iTwittt

More from this channel

• 5:15 How to get a list of files in folder in Excel

  Krishna S

  3,143 views · 30 June 2015

• 7:04 How to delete blank rows in Excel

  Krishna S

  3,455 views · 3 July 2015

• 7:38 How to create macro in Personal workbook

  Krishna S

  342 views · 16 August 2015

• 5:43 Copy of How to create your own Excel Add-in - Currency converter - number to text

  Krishna S

  113 views · 13 October 2015

• 3:03 How to format MS Excel cell comments

  Krishna S

  142 views · 20 November 2015

• 3:01 Spellnumber in MS Word Part 2

  Krishna S

  4,514 views · 20 November 2015

• 3:01 Spellnumber in MS Word Part 3

  Krishna S

  2,645 views · 20 November 2015

• 7:25 Excel cell referencing RELATIVE ABSOLUTE and MIXED

  Krishna S

  1,068 views · 14 January 2016