?
Solved

Change Excel Chart Colors from VB6

Posted on 2004-04-02
3
Medium Priority
?
628 Views
Last Modified: 2012-05-04
Hi Experts,
  I have data that I export to excel which is used by a chart that has already been set up.  The problem that I am having is with the color of the bars.  The user can specify what colors to use with a Common Dialog Box.  I get a 1004 error in the when I try to change the bar colors with this line:
ActiveChart.SeriesCollection(3).interior.colorindex = &H00FF0000&

  What is the right way to change the colors of the bars based on the user's input from the Common Dialog Box??
Thanks in advance!
-Ren
0
Comment
Question by:Ren
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 26

Accepted Solution

by:
EDDYKT earned 1600 total points
ID: 10742979
How about


ActiveChart.SeriesCollection(3).interior.color = &H00FF0000&
0
 
LVL 26

Expert Comment

by:EDDYKT
ID: 10742987
Or

ActiveChart.SeriesCollection(3).border.color = &H00FF0000&
0
 

Author Comment

by:Ren
ID: 10775216
I knew it would be something simple like that!  It was the word "index" and the end of "color" that seemed to be causing the problem  Thanks for the input!
-Ren
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Suggested Courses
Course of the Month10 days, 19 hours left to enroll

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question