Designate individual bar colour by CF in 3D graph

[mr_martin]

Hi!
Having searched many excel forums for ideas of how to, in a 3D graph, designate an individual bar colour to each 'z' value, by Conditional formatting, I feel I must post this question.
Must I enter a macro code to make this work? (I have come across a few).
Say I have a table of 10 rows x 16 columns, with values between 0 to 9.
Each value shall be designated its own colour.

I wish, with a second table, to toggle the colours.
This second table is just a row of the values 0 to 9, where, when I change the background colour of a value,
also the cells in the first table (10x16) with same value will change to selected colour.

In the end, the bars of same values in the 3D graph will display that specific colour.

So far, each row in the 3D graph is of the same colour.
Attached an example to visualize...
http://www.excelforum.com/attachment...1&d=1463938661
Thankful for any help!
All the Best,
Martin

[southward]

Hi,

Is this what you are looking for?
I found this macro on:

http://peltiertech.com/vba-condition...arts-by-value/

Please Login or Register  to view this content.

See attached.

Hope you find this useful.

[FDibbins]

Hi, welcome to the forum

Conditional Formatting (as far as I know) is formatting (cosmetics) that is applied to worksheet cells, based on certain criteria, I dont think it can be used in charts

[mr_martin]

Southward, thank you, brilliant !
I came a long way with that code. However, similar to other postings, only the first row of data was affected.
The remaining (x-axis) data remains unchanged.
I went ahead and modified the code according to tips on same thread, but I eventually got stuck
- please see screenshot of code line.

Been scratching my head for a few hours.
Attached my file with my advances, and screenshots.

All the best, and I am thankful for any push forward!
Martin

[southward]

Hi Mr Martin,

Sorry about that. I neglected to state that the Chart has to be selected before running the macro.
I also realize my previous example had the button assigned to the wrong version of the macro. My apologies.
The macro will take a few seconds to run. Length of time will depend upon PC capabilities and file size.

See attached.

Cheers

[mr_martin]

Thank you, Southward

Unfortunately, I did not manage to open / save with a functioning macro.
Could you copy paste the code herein?
Appreciate the effort for the button, that is a good feature. I must learn how to add this feature myself.

Best Regards,
Martin

[southward]

Hi Mr. Martin,

At a glance the macro that I have is the same as the one you have.

Please Login or Register  to view this content.

In order to not receive the error on :

Please Login or Register  to view this content.

you need to have the table selected before running the macro.

Good luck

[humdingaling]

Please Login or Register  to view this content.

just add this before the for each line to avoid having to select the table in order to avoid error

*replace chart 2 with whatever the chart is called of course

[mr_martin]

Hello Southward,

absolutely helpful, thank you.
Partly, I had added too much 'nice to have' coding, than staying with the basics.

Working well!

All the best,
Martin

[mr_martin]

Thank you Humdingaling,

I may very well need this in the future.

BRgds,
Martin

[southward]

Glad I could be of some assistance