Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart Series Formats lost when list re -sorted
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I display multiple series in a pie chart? | Charts and Charting in Excel | |||
How to select numeric 'series axis' in a surface chart? | Charts and Charting in Excel | |||
How do I pass series data x-value range to a chart from a cell? | Charts and Charting in Excel | |||
Hiding a non-plotted chart series in legend | Excel Discussion (Misc queries) | |||
change the format of a series in a chart | Charts and Charting in Excel |