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
-------------
If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.
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
Reply With Quote
Bookmarks