Is it possible to get an ON or OFF as coloured blocks in graph background ?

		Microsoft Office Forums > Microsoft Excel > Excel
Is it possible to get an ON or OFF as coloured blocks in graph background ?

03-27-2018, 02:42 PM

gebobs

Windows 7 64bit Is it possible to get an ON or OFF as coloured blocks in graph background ?

Office 2010 64bit

Expert

Join Date: Mar 2014

Location: Atlanta

Posts: 837

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

OnOff.xlsx (15.6 KB, 12 views)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
A background like a graph is appearing	mkrk	Word	1	04-19-2016 04:53 AM
column clustered bar graph with a line graph as secondary axis	Alaska1	Excel	2	06-09-2014 07:13 PM
Priority of line graph vs bar graph in terms of front to back positioning on a chart	DavePPointuser	PowerPoint	1	04-30-2014 10:57 AM
Printing with a coloured background	BillericayPete	Word	3	03-30-2012 06:29 AM
Graph Paper Background	brevace	Word	1	11-23-2011 12:20 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:10 AM.