473,385 Members | 1,379 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

OWC11 AxChartSpace - Colors

11
Hi,
i'm using the OWC11 AxChartSpace Component for a little statistic.
Everything works great, but i'm not very happy with the used colors in the ChartPie, so i want to change them.

So it looks like at the moment: http://img249.yfrog.com/i/chartcolors.jpg

For example i want to change the color of the "unbestätigt" Value, to green..but i have absolutely no idea how to do this. I only found a method which changes the backcolor...

Thank you for your help.

Greetings.
Jul 23 '09 #1
6 3882
PRR
750 Expert 512MB
I haven't touched office components for a long time... though i remember you can set colors of bar charts... i.e. add specific colors to the bars/pies etc...
Link
Expand|Select|Wrap|Line Numbers
  1. AxChartSpace1.Charts(0).SeriesCollection(0).Interior.Color="green";
  2.  
Jul 23 '09 #2
chrisli
11
Hi,
thanks for your answer.

You are right, with your posted code, i can change the Chart Categories colors, but only in ONE Color. Picture: http://www.pictureupload.de/pictures...artcolors2.JPG

Any additional ideas?

Greetings from Germany.
Jul 24 '09 #3
chrisli
11
Finally, i got it. What a mess. ;)

Here's the code:

Expand|Select|Wrap|Line Numbers
  1. myChart.Charts(0).SeriesCollection(0).Points(1).Interior.Color = "red"
  2. myChart.Charts(0).SeriesCollection(0).Points(0).Interior.Color = "green"
  3. myChart.Charts(0).SeriesCollection(0).Points(2).Interior.Color = "yellow"
  4.  
This took me so much time, just for finding out, that the added Categories are named ".Points"..
Jul 24 '09 #4
PRR
750 Expert 512MB
Welcome chrisli! Do continue to post on Bytes :)
Jul 24 '09 #5
chrisli
11
I'll try to. But beware, i'm still a beginner. ;)
Jul 24 '09 #6
PRR
750 Expert 512MB
I too consider myself beginner... there is lots to learn... you should consider posting answers.... you can certainly learn a lot that way ....
Jul 27 '09 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: STeve | last post by:
Hey guys, Just want to thank you guys in advance. I am receiving a "library not registered" error when I am running this code. I am not too sure why this is happening. I don't get this on the...
1
by: Stefan Hirtbach | last post by:
Hi, I wrote a small program in C#, using OWC11, that fills data in an excelsheet and save it to disk as xls-file (using the Export-function). It works well with Office 2003 but i've got problems...
1
by: Gerry Roston | last post by:
I'm not sure what I am missing... According to http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B319793, documentation for OWC11 is found in C:\Program Files\Common Files\Microsoft...
2
by: Gerry Roston | last post by:
I have a rather simple ASP.NET program for displaying a formatted spreadsheet. (Needless to say, there will be some data added!): Private Sub Page_Load(ByVal sender As System.Object, ByVal e As...
0
by: Julien | last post by:
Hi ! How can I add a field to an existing AxChartSpace ?? I have just a AxChartSpace, and I want to use it to show differents fields (The user could choose the field he want to see) I think I...
0
by: Hugo Flores | last post by:
I developed a Web project using Visual Studio 2005 Web Deployment Projects. I'm also using OWC11 for some charts. The problem I have is that when I transfer the deployment folders to the server I...
1
by: oliviers | last post by:
Hi, From an aspx (.net 2.0) web site, I basically want to provide my users with some data in an excel format. I found that a good way was to user the owc11 library (from Office 2003). It...
0
by: NagarajanS | last post by:
Hi, i developed a chering application using owc11 application in .net 2003.But now my office version is upgraded to OFFICE 2007.Now i try to run applciation is is searching for that OWC11...
2
by: jit007 | last post by:
HI all , I am creating a UI using VBA program where I am using OWC 11 control. What I want is that--- when user will select the pricular cell(say, D4) in the OWC spreadsheet, a combo box appears...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.