definning events along X axis

  • Thread starter Thread starter Uncle Buck
  • Start date Start date
U

Uncle Buck

I currently havre a pretty basic graph with time on the X axis and sales
along the Y. What I was wondering is whether there is a way to define
certain events on the graph to better put into context the sales
performance achieved during these events.

Example:
the graph already shows sales activity on a daily basis for the month
of may. I am open to any non pie-type graph that would allow me the
extra functionality of charting, in any reasonnable manner (other then
manualy touching up dates on the finished graph) these respective
dates:
-may 1 to may 5 as a promotional event
-may 12 to may 19th as a transition period
-may 28 to may 30 as a special marketing event

I'm open to any suggestions / software packages / ad-ons / questions
and am prommissing an honorable mention to anyone with any information
leading to the proper production of this graph, for whatever that's
worth!
 
Here's my 1st attempt at a solution. You didn't say what type of char
you are using, or any other details, but this worked for me, in on
form or another for a scatter plot, line graph, and a column chart.

1) Assume dates are in consecutive order in column A, sales figures fo
each date in column B.
2) In column C, in rows corresponding to event dates (include dates i
between start and end), enter the minimum Y value in the chart. Othe
rows left blank
3) Add column C as a series to the chart, formatted as a colored lin
without markers.

This gives colored lines that show the dates over which the event
occured.

As an extension, you could use more columns and additional series t
indicate different event types -- say a red line for the "promotional
event, a blue line for the "transition" event, and a purple line fo
the "marketing" event.

If it was hard to see on the X axis, set the value to something
little above the minimum Y value, or something near the maximum Y valu
to put the event lines near the top of the chart.

Was that worthy of an honorable mention:)
 
Mr Shorty, thank You!
I tried it and it works, it actually worked even better then I thought.
I've formatted the event data to show up as lines on the bar graph and
it looks GREAT! I'm even planning on layering over the competition's
events at certain heights (example; our events are along the bottom of
the Y axis; competitor A events are found 1/3 of the way up the Y axis,
competitor B events, 2/3 up). I showed the post to my boss and we were
both very impressed.

Although I can't include your name clearly on the report body, it will
be embossed in the document's information label section
(File/properties/Comments: "Based in part on conceptualization and
development advice from Mr.Shorty, www.excelforum.com) , I assure you.


Thanks again!
 
Back
Top