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

excel consultants - chart pivottable

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel consultants - Chart from PivotTable

excel consultants - Chart from PivotTable

ResolvedVersion Standard

Xiaojing has attended:
Excel Advanced course

Chart from PivotTable

Whenever I refresh the PivotTable, the chart changes back to its default format. I use the chart type of Line, but I don't want the default color and weight of the line. I change it, however when I refresh the pivotTable, the chart changes back. So how could I do to change the default of chart made by PivotTable?

RE: Chart from PivotTable

This should not happen you may need to reinstall excel

Excel tip:

Autonumber in Excel

To create an autonumber field, can use the Offset() function.

In cell A1, enter the number 1.
Then in cell A2, enter this formula:

=OFFSET(A2,-1,0)+1

Then copy the formula from cell A2, down as far as you need.

See also: Autonumber in Excel forum post.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.