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