asked on Conditionally format data series based on value
Dear Experts:
A macro should change the formatting for some custom named charts on the active Worksheet as follows:
Data Series that start in 2015 should have a different fill (RGB 230, 185, 184)
All of these charts are bar charts with just one data series
Not all of the charts of the active worksheet have to be formatted this way, but charts with the name 'MyChart_1', 'MyBizChart' and 'ProChart' (and other ones the names of which I will be able to enter into the provided macro code)
![conditionally-format-data-series.png]()
Help is much appreciated. Thank you very much in advance.
I have attached a sample file for your convenience.
Regards, Andreas
Conditionally-format-data-series.xls
A macro should change the formatting for some custom named charts on the active Worksheet as follows:
Data Series that start in 2015 should have a different fill (RGB 230, 185, 184)
All of these charts are bar charts with just one data series
Not all of the charts of the active worksheet have to be formatted this way, but charts with the name 'MyChart_1', 'MyBizChart' and 'ProChart' (and other ones the names of which I will be able to enter into the provided macro code)
Help is much appreciated. Thank you very much in advance.
I have attached a sample file for your convenience.
Regards, Andreas
Conditionally-format-data-series.xls
Microsoft ExcelVBA
Last Comment
Saurabh Singh Teotia
ASKER
Hi Saurab,
astonishingly nice workaround, thank you very much for it, but to be honest with you, I would favor a macro solution. Maybe you will be able to provide me even a macro code.
Andreas
astonishingly nice workaround, thank you very much for it, but to be honest with you, I would favor a macro solution. Maybe you will be able to provide me even a macro code.
Andreas
Andreas,
Any particular reason you are looking to this only by code??
Saurabh...
Any particular reason you are looking to this only by code??
Saurabh...
ASKER
Actually no specific reason
The reason i asked this question is because if i provide a macro solution for this i will be reading the range only from which you are preparing the chart and then coloring the series value accordingly...
Let me know if you are fine with the same and will write a macro for you...
Let me know if you are fine with the same and will write a macro for you...
ASKER
Hi Saurabh, great, this is ok, no problem, thank you very much in advance.
Regards, Andreas
Regards, Andreas
I'm confused whether you want me to write a macro or you are good with current solution??
ASKER
oh sorry that I confused you, yes I would be very glad if you could write a macro for me.
Regards, Andreas
Regards, Andreas
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Hi Saurabh,
great, works just fine, thank you very much for your professional job. I really appreciate it.
Regards, Andreas
great, works just fine, thank you very much for your professional job. I really appreciate it.
Regards, Andreas
Yw.. Glad to help.. :-)
Saurabh...
Conditionally-format-data-series.xls