You can add a dummy series, and put data labels onto its points and
error bars to generate custom gridlines. Here are a few examples:
http://peltiertech.com/Excel/Charts/...Gridlines.html
http://peltiertech.com/Excel/Charts/ArbitraryAxis.html
http://peltiertech.com/Excel/Charts/AddLine.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
Uncle Buck wrote:
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!