Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 66
Default Riding the Goal Line

I am displaying a chart where the peformance line matches the goal line for
several months in a row. The data line is hidden underneath the goal line,
so it looks like the data is missing - (even though it matched the goal). Is
there a way to pry the peformance data line out from under the goal line,
that is, to superimpose the data line over the goal line in such a way that
both lines are still visible?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,942
Default Riding the Goal Line

hi
yes. if the lines are running togeather, you may temporarily change one of
the values on one of the lines so that you can click each line seperately.
click on one of the lines.perferibly the one in "back". click format data
series.
you can also change which line is "in Back" by clicking the series order tab
and switching them.
but click on the patterns tab. for the line in "back", select a large
marker, a thick line and a dark color. for the line in "front", select a
smaller marker, a thinner line and a lighter color. click ok. play with it
till it is to your liking. if you temporarily changed a value, change it back
now.
Done.

regards
FSt1

"DOUG ECKERT" wrote:

I am displaying a chart where the peformance line matches the goal line for
several months in a row. The data line is hidden underneath the goal line,
so it looks like the data is missing - (even though it matched the goal). Is
there a way to pry the peformance data line out from under the goal line,
that is, to superimpose the data line over the goal line in such a way that
both lines are still visible?

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 66
Default Riding the Goal Line

FSt1: Thank you very much!

DOUG

"FSt1" wrote:

hi
yes. if the lines are running togeather, you may temporarily change one of
the values on one of the lines so that you can click each line seperately.
click on one of the lines.perferibly the one in "back". click format data
series.
you can also change which line is "in Back" by clicking the series order tab
and switching them.
but click on the patterns tab. for the line in "back", select a large
marker, a thick line and a dark color. for the line in "front", select a
smaller marker, a thinner line and a lighter color. click ok. play with it
till it is to your liking. if you temporarily changed a value, change it back
now.
Done.

regards
FSt1

"DOUG ECKERT" wrote:

I am displaying a chart where the peformance line matches the goal line for
several months in a row. The data line is hidden underneath the goal line,
so it looks like the data is missing - (even though it matched the goal). Is
there a way to pry the peformance data line out from under the goal line,
that is, to superimpose the data line over the goal line in such a way that
both lines are still visible?

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
Creating a goal or target line Lintless Charts and Charting in Excel 1 February 22nd 08 06:01 PM
Goal Line Going Forward TinleyParkILGal Charts and Charting in Excel 1 December 22nd 07 10:18 AM
Goal line? TJH Charts and Charting in Excel 1 February 14th 07 11:21 AM
How do I set a goal line in a bar graph? mtwelsh72 Charts and Charting in Excel 3 April 14th 06 05:55 PM
How do I create a goal line on a bar chart? dragon4 Charts and Charting in Excel 2 December 30th 04 09:35 PM


All times are GMT +1. The time now is 04:16 PM.

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

About Us

"It's about Microsoft Excel"