Got a problem that may be possible (but I doubt it) to solve.
I have a table as below showing figures by hour, by day.
Day hh: ->
Mon
Tues
Each of the cells is coloured dependant on what is going on in that specific hour.
I make a 3D bar chart of these, is it possible for the colours to be shown on the charts without changing each bar manually?
Not sure whether thats possible, but with your chart active, go to Tools > Options > Colour, there's an option for changing colours in charts.
Does that help?
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Not in the slightest. [=
the bars need to be the same colour as the cells it takes the data from.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks