charts

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Charts

Charts

resolvedResolved · Low Priority · Version 2007

An has attended:
Excel Advanced course

Charts

When you have different data items that you represent in a chart and you have multiple versions of this chart where not all data items in the legend appear, how can you make sure that every data item (e.g. the name of a country) is represented in the chart in the same colour? E.g. US is always green, UK always yellow,... (even though the UK or US do not appear in each chart; the colours seem to be chosen randomly each time you do a chart with the same data)

RE: Charts

Hi An

Are you referring to charts created by selecting data and using Insert - Chart; or a PivotChart?

Thanks
Amanda

RE: Charts

I think I had the problem when doing pivot charts.
but I would be interested in the solution in both cases.
thanks

RE: Charts

Hello An

Please use the following link to see another post where a similar question was asked:
https://www.stl-training.co.uk/post-9694-pivot-tables.html

Kind regards
Amanda

Mon 15 Dec 2008: Automatically marked as resolved.


 

Excel tip:

Sum Up All the Values in A Column

If you want to quickly calculate the Summed values of all cells in a column in Excel 2003 normally you would use the SUM formula. (eg if you wanted to calculate the values in Column C rows 10 to 25) the formula would be:

=SUM(C10:C25)

However, if you keep adding values to column C you would keep having to modify the above SUM formula which can get quite annoying.

To get around this you can sum all the values in a column using the following formula:

=SUM(COLUMN:COLUMN)

Which, in our example, would be:

=SUM(C:C)

NOTE You cannot place this formula in column C, or else Excel 2003 will show a circular reference error.

The formula must be placed in any other column, EXCEPT the one being calculated.

View all Excel hints and tips


Server loaded in 0.08 secs.