In Microsoft Excel 2010, when I insert a chart with multiple data series (or a pie chart), each series (or slice) is automatically given a colour. My 2 questions are:
What is the formula used to generate these automatic colours?
Can I append a row or column of colour values in hex format (e.g. #ff9900 for orange) to the data, so that their respective graphs are appropriately coloured?
Bonus pointsEven better if I can also specify the marker colour, shape, size, etc.
Are the answers the same for other versions of Excel?