Formatting of graphs dependending on input given

[Climaxgp]

Hey Guys!

Is it possible to create a bar graph and have the bar change colour depending on the values inputed?

For example: If i have sales of 100 the bar on the graph should show red in colour, if i have sales of 150 the bar should show orange in colour and if i have sales of 200 the bar should show green in colour

[Climaxgp]

Anyone....

[mubashir aziz]

I think it can be thru macro but my macro skill is not good although i'm attaching a sample file. may be it will be helpful for you ......

[arthurbr]

Your post does not comply with Rule 5 of our Forum RULES. We have Seven question forums: Miscellaneous, General, Programming, Worksheet Functions, Charting, Excel 2007 Help and New Users. Please choose the appropriate forum, and post your question in ONLY one forum.

Your thread will be transferred to the correct forum

[Andy Pope]

bumping you thread after a whole 34 minutes, it must be important :P

Use multiple series with formula to determine which of the series gets the value and which gets zero.

The set the Overlap value to 100.

Search forum for conditional charts.

[Climaxgp]

@ Mubashir- Thank you!! It works perfectly!!

@Andy- It was important, i sold my mouth to someone thinking i was able to do it