Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 18th 09, 06:51 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 447
Default Threshold Line Across Chart

I have a column chart that I created in Excel 2003. It plots percentages for
each month of the year. The data ranges from 22% - 34%. I want to add a line
for my threshold that will go across the chart at 18%. How can this be done?
HELP!
Thanks, Karen

  #2   Report Post  
Old May 18th 09, 07:51 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2009
Posts: 39
Default Threshold Line Across Chart

Karen,

You can add another data series.
--
Regards,
Eddie
http://www.HelpExcel.com


"Karen" wrote:

I have a column chart that I created in Excel 2003. It plots percentages for
each month of the year. The data ranges from 22% - 34%. I want to add a line
for my threshold that will go across the chart at 18%. How can this be done?
HELP!
Thanks, Karen

  #3   Report Post  
Old May 19th 09, 01:18 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 6,582
Default Threshold Line Across Chart

There are a couple techniques:

http://peltiertech.com/Excel/Charts/AddLine.html

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/

Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"Karen" wrote in message
...
I have a column chart that I created in Excel 2003. It plots percentages
for
each month of the year. The data ranges from 22% - 34%. I want to add a
line
for my threshold that will go across the chart at 18%. How can this be
done?
HELP!
Thanks, Karen





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
Goal line or target line to Excell 2007 Chart hawaiiham2000 Charts and Charting in Excel 5 October 2nd 09 05:35 PM
bar chart with threshold john Charts and Charting in Excel 4 March 1st 07 02:04 PM
putting in threshold line that easily depicts reaching a goal KS Charts and Charting in Excel 1 January 12th 07 10:19 PM
How do I show a threshold line in an Excel chart? Ben Charts and Charting in Excel 1 December 6th 06 07:03 PM
Make a line in a bar chart, and change color of any bars that exceed the line MarkM Excel Discussion (Misc queries) 4 July 5th 06 04:06 PM


All times are GMT +1. The time now is 01:51 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