| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Make a line in a bar chart, and change color of any bars that exceed the line
I need to make a bar chart that contains a line, and any bar in this
chart that exceeds this line will change color, say from green to red. For instance, if I had a population bar chart, and any city whose population exceeded the line drawn at 1,000 would cause their bar to change from green to red. If anyone can help, it would be greatly appreciated. Thanks, Mark |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Make a line in a bar chart, and change color of any bars thatexceed the line
Andy Pope has instructions for a conditional line chart:
http://www.andypope.info/charts/conditionalline.htm MarkM wrote: I need to make a bar chart that contains a line, and any bar in this chart that exceeds this line will change color, say from green to red. For instance, if I had a population bar chart, and any city whose population exceeded the line drawn at 1,000 would cause their bar to change from green to red. If anyone can help, it would be greatly appreciated. Thanks, Mark -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Make a line in a bar chart, and change color of any bars thatexceed the line
Hi,
I think Jon's page is move appropriate as the OP wants the bars to change colour rather than the goal line. http://peltiertech.com/Excel/Charts/...nalChart1.html Cheers Andy Debra Dalgleish wrote: Andy Pope has instructions for a conditional line chart: http://www.andypope.info/charts/conditionalline.htm MarkM wrote: I need to make a bar chart that contains a line, and any bar in this chart that exceeds this line will change color, say from green to red. For instance, if I had a population bar chart, and any city whose population exceeded the line drawn at 1,000 would cause their bar to change from green to red. If anyone can help, it would be greatly appreciated. Thanks, Mark -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Make a line in a bar chart, and change color of any bars thatexceed the line
Thanks Andy -- I misread it as a "line chart"
Andy Pope wrote: Hi, I think Jon's page is move appropriate as the OP wants the bars to change colour rather than the goal line. http://peltiertech.com/Excel/Charts/...nalChart1.html Cheers Andy Debra Dalgleish wrote: Andy Pope has instructions for a conditional line chart: http://www.andypope.info/charts/conditionalline.htm MarkM wrote: I need to make a bar chart that contains a line, and any bar in this chart that exceeds this line will change color, say from green to red. For instance, if I had a population bar chart, and any city whose population exceeded the line drawn at 1,000 would cause their bar to change from green to red. If anyone can help, it would be greatly appreciated. Thanks, Mark -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Make a line in a bar chart, and change color of any bars that exceed the line
Thanks to all who replied. Jon's page worked out great.
Mark Debra Dalgleish wrote: Thanks Andy -- I misread it as a "line chart" Andy Pope wrote: Hi, I think Jon's page is move appropriate as the OP wants the bars to change colour rather than the goal line. http://peltiertech.com/Excel/Charts/...nalChart1.html Cheers Andy Debra Dalgleish wrote: Andy Pope has instructions for a conditional line chart: http://www.andypope.info/charts/conditionalline.htm MarkM wrote: I need to make a bar chart that contains a line, and any bar in this chart that exceeds this line will change color, say from green to red. For instance, if I had a population bar chart, and any city whose population exceeded the line drawn at 1,000 would cause their bar to change from green to red. If anyone can help, it would be greatly appreciated. Thanks, Mark -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change line in Chart | Charts and Charting in Excel | |||
| how to change line spacing for text box in excel chart | Charts and Charting in Excel | |||
| How to change a bar to line in a combo chart? | Charts and Charting in Excel | |||
| Activating a Chart object | Charts and Charting in Excel | |||
| In mixed bar and line chart. I cannot change one of my source da. | Charts and Charting in Excel | |||
Linear Mode
