I am trying to create 10 charts auomatically from sequential pages. The data
is simple; dates in Column A, titles accross the top, and values in the body.
6 lines of data. I ran the wizard and picked up most of the coding. However,
when the code runs it does not give the dates consistently at the bottom of
the charts. Do I assign the xValue or am I barking up the wrong tree? I
can't figure out the code format or I must be somethiong withthe xvalue
statemnet. I eventually want to assign the colors and line size based on the
category, but i can't get past first base!

If any one has an example of this process and possibly assigning colors I'd
REALLY appreciate it!

Thanks

How is it inconsistent? Use SetSourceData to define the range of data that includes
the dates and headers.

Excel will likely provide a time-scale axis if it recognizes the data as dates. This
means it will make a proportionally spaced axis, instead of an axis with a tick at
each date. If you want a tick mark for each date, with equally spaced ticks
regardless of the duration between ticks, go to Chart Options on the Chart menu, and
on the Axes tab, choose the Category option for the Category (X) Axis.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Candyman wrote:
I am trying to create 10 charts auomatically from sequential pages. The data
is simple; dates in Column A, titles accross the top, and values in the body.
6 lines of data. I ran the wizard and picked up most of the coding. However,
when the code runs it does not give the dates consistently at the bottom of
the charts. Do I assign the xValue or am I barking up the wrong tree? I
can't figure out the code format or I must be somethiong withthe xvalue
statemnet. I eventually want to assign the colors and line size based on the
category, but i can't get past first base!

If any one has an example of this process and possibly assigning colors I'd
REALLY appreciate it!

Thanks