Hi All,

I am programmatically creating a chart and I believe it is cleaner to do it
by having vba throw values into the chart rather than throw the values into
cells for the chart to read off.

I have no probem creating the chart and having it display as required but I
am meeting with frustration with the associated data table.

I format he numbers of the graph to be a percentage through:

ActiveChart.Axes(xlValue).TickLabels.NumberFormat = "0.00%"

This is fine but this does not transfer to the data table. The table will
display the values in their decimal form instead. Is there a way to fix
this?

Also is there a way to label the data table columns? Without referencing
cells. I know when creating the series it only lets me title the values
through a cell range, can i manually add the series titles through vba
instead?

eg

my data table depics 1 2 3 4 as the titles but I want to change these to
meaningful names.

Apart from this nuisance vba has done well for creating a graph without
direct reference to cells for the values.

Help is appreciated and I thank any helps in advance.

Regards,,
Clint