Problem in displaying the chart

[ramkumar_cpt]

Hi all,

Good evening. I am facing one problem at creating chart. This is my coding.


Charts.Add
ActiveChart.ChartType = xlBarClustered
ActiveChart.SetSourceData Source:=Sheets("Data").Range("A5:E6"), PlotBy:= _
xlRows
ActiveChart.Location Where:=xlLocationAsObject, Name:="Cost"
With ActiveChart
.HasTitle = True
.ChartTitle.Characters.Text = _
"5 Time Predictability of Design and Construction"
.Axes(xlCategory, xlPrimary).HasTitle = False
.Axes(xlValue, xlPrimary).HasTitle = False
End With



I have 4 sheets in my excel. Such as Start, Industry Radar, Cost, Data.
I want to create chart using "Data" sheet value and displayed that chart in Cost sheet. I have created it. In my system it is working fine. But in my friend system The chart is displayed in first sheet(It is displayed in start sheet). But i have to displayed in Cost sheet. Pls help me why this problem? I am using office 2003. My friend is using office 2000.

[Tushar Mehta]

Is it possible the Cost sheet is protected on your friend's computer?

Do you have any 'On Error {something}' clause in your code? If so, get
rid off it and try the code again.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <[email protected]>,
[email protected] says...
>
> Hi all,
>
> Good evening. I am facing one problem at creating chart. This
> is my coding.
>
>
> Charts.Add
> ActiveChart.ChartType = xlBarClustered
> ActiveChart.SetSourceData Source:=Sheets("Data").Range("A5:E6"),
> PlotBy:= _
> xlRows
> * ActiveChart.Location Where:=xlLocationAsObject, Name:="Cost"*
> With ActiveChart
> .HasTitle = True
> .ChartTitle.Characters.Text = _
> "5 Time Predictability of Design and Construction"
> .Axes(xlCategory, xlPrimary).HasTitle = False
> .Axes(xlValue, xlPrimary).HasTitle = False
> End With
>
>
>
> I have 4 sheets in my excel. Such as Start, Industry Radar, Cost,
> Data.
> I want to create chart using "Data" sheet value and displayed that
> chart in Cost sheet. I have created it. In my system it is working fine.
> But in my friend system The chart is displayed in first sheet(It is
> displayed in start sheet). But i have to displayed in Cost sheet. Pls
> help me why this problem? I am using office 2003. My friend is using
> office 2000.
>
>
> --
> ramkumar_cpt
> ------------------------------------------------------------------------
> ramkumar_cpt's Profile: http://www.excelforum.com/member.php...o&userid=28673
> View this thread: http://www.excelforum.com/showthread...hreadid=485822
>
>