Chart Series Formats lost when list re -sorted
:confused: Hi, I have created a bubble chart where I have set specific colours to each series. However if I then sort the source table (this not a pivot table just a list) the formating doesn't follow and they all change. Any way to fix the format so this doesn't happen and I keep consistent colours irrespective of sorting the source data ? regards Greg -- Fullam ------------------------------------------------------------------------ Fullam's Profile: http://www.excelforum.com/member.php...o&userid=33363 View this thread: http://www.excelforum.com/showthread...hreadid=538528 |
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 |
All times are GMT +1. The time now is 12:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com