Problem in displaying the chart
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 |
All times are GMT +1. The time now is 03:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com