Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Series Formatting changes when I save and reopen a document
I have created a pivot chart and table from a spreadsheet that contains
formulas that derive values of other cells. I have added formatting for the data series and saved the document, when I reopen, the formatting is incorrect. It retains the colors I've used but loses the association with the series and the series order. Any thoughts will be greatly appreciated. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Series Formatting changes when I save and reopen a document
Have you tried using, Format, then Conditional?
"LaVerne" wrote: I have created a pivot chart and table from a spreadsheet that contains formulas that derive values of other cells. I have added formatting for the data series and saved the document, when I reopen, the formatting is incorrect. It retains the colors I've used but loses the association with the series and the series order. Any thoughts will be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Action Pane is disabled when I save the document and reopen. | Charts and Charting in Excel | |||
Difficult for me, probably basic to you | Excel Worksheet Functions | |||
Formatting cells is not retained when saved as csv file | Excel Worksheet Functions |