Thread: Is it possible to get an ON or OFF as coloured blocks in graph background ?
View Single Post
 
Old 03-27-2018, 02:42 PM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
  
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default
Make another column where each On =1 and each Off = 0. Make your chart a combo with this data as column type with gap width = 0
Attached Files
File Type: xlsx OnOff.xlsx (15.6 KB, 12 views)
Reply With Quote