Printable View
HELLO,
I am Using VBA Chart tool to display a chart and it also has label showing values (43,27 ,32 ,31 etc....).
is there any way we can conditionally format chart label.
for eg if label value is negative than show label in red color, if value is positive than show it in green.
Attachment 29853
http://www.vbaexpress.com/forum/imag...AAAElFTkSuQmCC
what kind of chart are you using Modern chart?
Am using chart tool
Attachment 29856
http://www.vbaexpress.com/forum/imag...AAAElFTkSuQmCC
You are neither using Access nor VBA, but .Net. - I suggest you find a forum, which covers .Net WinForms programming, as you are much more likely to find someone who is familiar with that topic.
Maybe research in the documentation of the Series class and it's children may also help.
Sorry "old" thread but whilst it suggests the thread was solved, to me it clearly wasn't.
To make negative numbers in an Excel chart appear in a different colour, you can change the negative number style for the cells in the chart:
1. Select the cells you want to format
2. In the Category box, click Number or Currency
3. Under Negative numbers, select an option for negative numbers
You can also change the colour of a chart by using the Chart Styles button:
1. Click the chart you want to change
2. In the upper-right corner, click Chart Styles
3. Click Colour and pick the colour scheme you want
This thread wasn't about an Excel chart!Quote:
Originally Posted by Aussiebear
While the OP claimed to use VBA, the second screenshot clearly shows that he is using a .Net Chart control in Visual Studio.
Thank you PhilS for your reply, however since this forum isn't about .Net, the solution supplied gives those viewing this thread an option for completing the same task within EXCEL.