legend problem

Have a pivot chart with some series titles in the legend that I want to change. I click on the series, go to Analyze in the Pivot Chart tools, go into the Active Field and edit the name. One series works just fine, but the other one won't keep the edited name. It just reverts to the original...

Hi, So I have a graph with a legend on the RHS. If I go to design - select data and hen arrange he order of the legend to the order I want via the arrow buttons, it is not in sync with the actual legend (only one graph). If I go to the graph and click the filter button that appears (top right...

Hi all, There are a lot of spreadsheets we use at work that live on a shared network. Every time I create a plot in one of them, I set the legend font size to 10. After other people have opened it to do their part (on a completely separate tab, mind you), the font size starts decreasing. If...

I have a line chart where the data behind uses formulas to populate the values. Sometimes there aren't values for a particular month so I've use the N/A# error to stop these plotting. However, I'd like to be able to remove certain data series from the legend if EVERY value is N/A#. I've seen...

I have created an XY Scatter plot and inserted a picture for each data series rather than using the standard marker. It is essentially a bubble with a number in the middle of each bubble (e.g. a blue circle with a 1 inside). I would like for my legend to show the corresponding colored bubble...

Hello all, In my Dynamic Bubble chart, I have used offset formula in Named ranges for relevant criteria, but my Legends don't pick up individual products, I have switch legend on, its just dumped as one. Same problems with data labels. I need to pick up Product names for each Bubble without...