I'm having some irritating difficulty with the graphing in Excel 2013. For a variety of reasons, I prepare graphs so they have their own sheet, with the data they pull from on a separate sheet. In any given workbook, I'll likely have things organized like this:
Sheet1: Graph A
Sheet2: Graph B
Sheet3: Graph C
Sheet4: Data A
Sheet5: Data B
Sheet6: Data C
I just recently switched from 2010 to 2013 and am now having an irritating issue with the colours of the graphs. On each of Graph A, B, and C, the colours are different. That is, the first data series in Graph A is blue, in Graph B it is Orange, and in Graph C it is grey. All the colours rotate this way through the tables.
I don't want this. In 2010, the graphs had a default colour scheme that never changed. How do I get that back? My charts have many data series in each of them and I do not want to have to make this change manually...
The "Change Colors" option does not help. The default is this rotating colour business that is insanely stupid.
Sheet1: Graph A
Sheet2: Graph B
Sheet3: Graph C
Sheet4: Data A
Sheet5: Data B
Sheet6: Data C
I just recently switched from 2010 to 2013 and am now having an irritating issue with the colours of the graphs. On each of Graph A, B, and C, the colours are different. That is, the first data series in Graph A is blue, in Graph B it is Orange, and in Graph C it is grey. All the colours rotate this way through the tables.
I don't want this. In 2010, the graphs had a default colour scheme that never changed. How do I get that back? My charts have many data series in each of them and I do not want to have to make this change manually...
The "Change Colors" option does not help. The default is this rotating colour business that is insanely stupid.
