Chart Series Formats lost when list re -sorted
I am having a similar problem. I have set up a data table and created a list
out of it so I can add additional data over time. From this list, I have also
set up multiple charts in which specific data series are compared in each
chart. Since each data series appears in multiple charts, I have colored each
data series the same so it is constant when moving from chart to chart.
When I add new data to the series, the data correclty appears on the charts
and the formatting (color reference in the legend) also remains to the
settings I had previously specified. However, when I save the workbook, exit,
and re-open the workbook, all formatting is lost. Thus my color referencing
for each data series is non-existant. Considering the number of charts and
data series I have, it is too time consuming to reformat each data series in
every chart.
I would greatly appreciate it if someone could explain how to prevent this
from happening, or if this problem could be fixed in a update.
Thank you,
Jasen
|