Barchart.datasource =A1:C4???

[kingz2000]

Hi,

I have an excelfile with a barchart whereby I am trying to dynamically fill the datasource of a diagram with my code. Assuming the diagram values& column headings are in the range A1:C4.HOw can I allocate the datasource of the Chart to this range per code???

 

[PHV]

Have you tried to play with the macro recorder ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[kingz2000]

no. I was assuming it would be quite a straight forward code. like micrisft.chart.datasource or somehting. I have never tried the makro thing.

 

[SkipVought]

As PHV suggested, macro record setting the series data source.

THEN observe the code that the recorder generated.

Alternatively, I like to use Named Ranges for my source data if the range will continually change. Check out How can I rename a table as it changes size faq68-1331 for the OFFSET workbook function. The range name can be used in the Series X & Y values in the form...
[tt]
=MySheet!MyRangeName
[/tt]
No VBA required.

Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount!}