Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a goal or target line | Charts and Charting in Excel | |||
Goal Line Going Forward | Charts and Charting in Excel | |||
Goal line? | Charts and Charting in Excel | |||
How do I set a goal line in a bar graph? | Charts and Charting in Excel | |||
How do I create a goal line on a bar chart? | Charts and Charting in Excel |