How does the Series of a chart was set by default?

[happyjanezj]

I have some questions on the office chart:
First,I want to know that there are how many series at most can be set in a
chart of Excel or Word?
Then ,when we add a group of data to a chart , a series would be add to the
chart automaticly which is different with other series. How does office did
it ?just set the RGB color? Why the colors not even look the same ?
IF there are 1000 series which is much more than the number of colors which
can be select ,how do the series be set different with each other ?
Thanks!

 

[Roger H. Levy]

Past posts in the related NGs have said that the maximum number of series is
255. It also seems to be the case that the maximum data set size per series
is 3999 for MSChart (e.g. charts in Word) however I have not found this
limit to exist for Excel charts.

I suppose it is believed that with a maximum of 255 series it is possible to
choose enough different colors and line styles.

 

[Steve Rindsberg]

I have some questions on the office chart:
First,I want to know that there are how many series at most can be set in a
chart of Excel or Word?

That's two different charting applications, then. Excel charts use Excel; in
Word or other Office apps, when you do Insert, Chart, you get a chart from
MSGraph; it's similar to but not entirely identical to the charting engine in
Excel.

Then ,when we add a group of data to a chart , a series would be add to the
chart automaticly which is different with other series. How does office did
it ?just set the RGB color? Why the colors not even look the same ?
IF there are 1000 series which is much more than the number of colors which
can be select ,how do the series be set different with each other ?

In both charting engines, there's a limit of 56 colors, some of which may be
duplicates.

You can change the colors in Excel, but in MSGraph, while you can change them
manually, you can't do it programmatically.

 

[happyjanezj]

Thank u Steve and Roger, some surprised by your quickly answer!
It is very helpful for me that I know in Excel charts , there are 256 series
and 56 colors at most, and now I can set my chart by vba.

Thanks a lot for all your reply.