ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Riding the Goal Line (https://www.excelbanter.com/excel-worksheet-functions/178578-riding-goal-line.html)

DOUG ECKERT[_2_]

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?

FSt1

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?


DOUG ECKERT[_2_]

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?



All times are GMT +1. The time now is 03:48 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com