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