Somebody from the forum help me with the below code which worked great for colouring a bars on a bar chart. I now wanted to use the code and apply to another chart within the same workbook. But I cannot figure out what part of the code is refering to the actual chart?
Can anyone help point this out to me?
Please Login or Register to view this content.
This line:
refers to the first chart on the worksheet with the pivot table on it.Please Login or Register to view this content.
Remember what the dormouse said
Feed your head
So how would I refer to the second?
Please Login or Register to view this content.
Also is it possible to refer to more than 1 chart at a time?
That is correct. For more than one chart you must use a loop or more than one variable. If you will make same changes for each chart, a loop will be better.
Last edited by Izandol; 06-11-2014 at 08:34 AM.
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks