I'm building Stacked Column chart with VBA. What I want is to stack the data in column I and G together for every compaies and separated by company. Folowing is the code which gives me a big trunk instead of the blocks separated by companies. The column A is the company name.
Thank you very much in advance.
Please Login or Register to view this content.
Last edited by dhartford; 01-02-2009 at 06:09 PM.
Try this,
If not post example workbook.Please Login or Register to view this content.
Andy,Originally Posted by Andy Pope
Wow! You are Hero. It is exactly what I want. Thank you so much. Could you explain to me with more details, such as why there is no loop needed, the syntax of formula of stacked chart...
Very appreciate.
You do not need to create a series for each point.
I started by creating the chart manually and inspecting the series Formula.
There you would see that the rows are specified as a range within a single series. Where as your code was plotting each row in each column.
Please don't cross post without including links.
Last edited by Andy Pope; 12-30-2008 at 12:04 PM.
I got it. Thanks again.
I have another queation if you don't mind. This is about chart title.
1. How to code a subtitle? e.g. in the following code, I want Date and Model to be on the next line of "Attach Exhaustion"
2. What is the chart property to change the font and size?
Your help is greatly appreciated.
Please Login or Register to view this content.
This is the sort of code needed to format all or parts of the title
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks