Changing Data Table Formula in ChartObject

[Phathi]

Hi,

I'm not an excel expert and I don't know if this is possible.

I received an excel print-out from a client which displays a chart that spreads over a timeframe.

I need to reproduce this layout from a VB program which gets it data from Oracle.

I have managed to create the chart and it's series... however the data table displays wrong data. I would like it to display highs;lows;averages etc

e.g.

-----Attempts Low:19283 High:39393 Average:383738
-----Rejects Low:11223 High:99423 Average:863738
-----et cet

What I need is someone to tell me if it is possible to manipulate the data table formula to produce this.

I would appreciate a yes or no, especially if this is impossible.

Thanks

 

[Dreamboat]

The best way to produce data for a chart, regardless of the manner in which you retrieve the data is (and I'm using A1 as the top, left-most cell of the data range):

If labels on X axis only:

Row 1 contains labels
Row 2 contains series 1
Row 3 contains series 2
(or vice-versa: column 1 contains labels, column 2...)
Selection is A1:last cell of data

If labels on X and Y axes:

A1 is blank
A2 contains first label
A3 contains 2nd, etc.

B1 contains first label
C1 contains 2nd label, etc.

B2 is first cell of first record.
Selection is A1:last cell of data

Hope this makes sense and is of help. I'm never sure about questions like this. Is it the layout or is it the VBA? Hmmm...
techsupportgirl@home.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word