Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |