excel consultants - chart pivottable

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

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

excel consultants - Chart from PivotTable

resolvedResolved · Low Priority · Version 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:

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


Server loaded in 0.09 secs.