Does anyone know how to show when an event started. I will explain. I have a chart showing two things in line graph form. I want to show when something (like advertising) started so I can see the growth from when the advertising started without disturbing the other graphed relationships. Need to know ASAP, thanks x-)
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel Chart
- Thread starter cds35
- Start date
This solution MAY work for you...
To show an event for any single "line", copy the
data series - so you will have two identical lines
on top of each other. Next, delete all data points
for one of the lines before the "event". Then,
format that data series to have a different line
color. The graph will now have a line which changes
color after your "event". You can then have the
legend describe the change (i.e. yellow = sales
before advertising, green = sales after advertising).
To show an event for any single "line", copy the
data series - so you will have two identical lines
on top of each other. Next, delete all data points
for one of the lines before the "event". Then,
format that data series to have a different line
color. The graph will now have a line which changes
color after your "event". You can then have the
legend describe the change (i.e. yellow = sales
before advertising, green = sales after advertising).
- Status