Chart Source data

[mk000]

How do you make a chart's source data shift one cell to the right via macro?

Example....

____A______B_______C_______D________E
1_________JAN_____FEB_____MAR______APR
2 USA____5_______4_______3________2

Say the current data on the chart is USA's JAN - MAR, with the macro, it's now FEB-APR


Thanks!

 

[sweater_vests_rock]

mk000.

Use the SetSourceData Method. From the Help File:

SetSourceData Method

Sets the source data range for the chart.

expression.SetSourceData(Source, PlotBy)

expression Required. An expression that returns a Chart object.

Source Required Range. The range that contains the source data.

PlotBy Optional Variant. Specifies the way the data is to be plotted. Can be either of the following XlRowCol constants: xlColumns or xlRows.

Example
This example sets the source data range for chart one.

Charts(1).SetSourceData Source:=Sheets(1).Range("a1:a10"), _
    PlotBy:=xlColumns[/quote]

 

[mk000]

can you demonstrate a macro to shift the cells one cell?

???