Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 5th 06, 12:03 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2
Default 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   Report Post  
Old July 5th 06, 12:59 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,979
Default 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   Report Post  
Old July 5th 06, 01:16 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,489
Default 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   Report Post  
Old July 5th 06, 01:36 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,979
Default 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   Report Post  
Old July 5th 06, 04:06 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change line in Chart JeroenM Charts and Charting in Excel 4 October 26th 05 08:07 AM
how to change line spacing for text box in excel chart Anne Charts and Charting in Excel 1 October 5th 05 12:11 AM
How to change a bar to line in a combo chart? KimD Charts and Charting in Excel 2 August 10th 05 06:23 PM
Activating a Chart object Hari Prasadh Charts and Charting in Excel 6 August 2nd 05 07:22 PM
In mixed bar and line chart. I cannot change one of my source da. bluetractorboy Charts and Charting in Excel 1 January 21st 05 03:17 PM


All times are GMT +1. The time now is 11:40 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017