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 Whe=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

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 ,
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 Whe=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