Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 41
Default Odd Chart Format Results

I have two sheets with charts on both... Sheet1 and all it's charts are dead on.
However, when I copied the code from Sheet1 to Sheet6 I am getting "odd things" happening.
The Chart(s) are repeated 5 times using different data represented by the "Range("A"...." line of code

Here is the opening code:
With Sheet6
.Shapes.AddChart.Select
ActiveChart.ChartType = xlCylinderBarClustered
ActiveChart.SetSourceData Source:=Range("A" & lFirstRow & ":B" & lLastRow)
End With

I should be getting just a basic Cylinder Bar Chart. The first chart comes out correctly formatted based on the code(all the Cylinders are the same color, the series are correct etc...)=SERIES(Sheet6!$B$248,Sheet6!$A$249:$A$278, Sheet6!$B$249:$B$278,1)
but the other four charts =SERIES(Sheet6!$A$198,,Sheet6!$B$198,1) are giving me individual horizontal series as well as coloring the cylinders different colors.
I cannot figure out why I am getting two different results.
Any ideas would be appreciated!
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 3,872
Default Odd Chart Format Results

Hi Hans,

Am Wed, 12 Dec 2012 06:00:49 -0800 (PST) schrieb Hans Hamm:

Here is the opening code:
With Sheet6
.Shapes.AddChart.Select
ActiveChart.ChartType = xlCylinderBarClustered
ActiveChart.SetSourceData Source:=Range("A" & lFirstRow & ":B" & lLastRow)
End With


all ranges between "With Sheet6" and "End With" must have a point in
front of the range keyword, e.g. .Range("A".... or .cells(1,1) to
refere them to the sheet


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
condtional format - hightlight max results Nadine Excel Discussion (Misc queries) 4 July 10th 08 04:48 AM
Format results from using INDEX JE Excel Discussion (Misc queries) 3 June 2nd 08 07:33 PM
Format results in Message Box Jim G Excel Discussion (Misc queries) 3 February 28th 07 01:03 AM
Format results of Macro jcmcknight Excel Programming 2 October 13th 06 03:01 AM
format results of a formula mtTry Excel Discussion (Misc queries) 7 July 26th 06 12:05 AM


All times are GMT +1. The time now is 07:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"