excel consultants - Chart from PivotTable

Resolved · Low Priority · Version Standard

Wed 2 May 2007, 12:06 Delegate Xiaojing said...

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?

Fri 4 May 2007, 14:49 Trainer Garry said...

RE: Chart from PivotTable

This should not happen you may need to reinstall excel

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Manually rotating a 3D chart

To manually rotate a 3D chart;
Select the chart (edit mode) and click on one corner of the chart display area. A selection border will appear, using the left mouse button on one of the chart's "corners" (mouse pointer changes to a cross) drag the image which becomes a line representation of the chart (as you begin to drag) and rotate the chart to a view of your choice.
If you dont get it right first time, dont worry, the manoeuver is a little bit tricky.

View all Excel hints and tips