series name

Hello All, I've written some VBA which turns an array into a stacked bar chart where series with the same name are coloured the same. However, having multiple series with the same name has led to a rather pointless legend with multiple duplicates. My main two questions are: 1) Is there a way...

Hello, I have a bar chart that 4 command buttons are connected to. Initially I had successfully set up the command buttons to add a data series on the first click and then remove the data series on the 2nd click. However, when I initially coded these the data series were static (1, 2, 3, etc.)...

I have a worksheet that contains variable data in one column and the location it came from in another. I want to chart all the data in the one column based on its location. For example if my worksheet looked like this: Data Location 21 1 342 1 312 2...

Hi All, Is there a way to use a sort of names range, to chart from a pivot? I currently have an ‘analysis’ worksheet which displays two pieces of data from two pivot tables, which are on different worksheets. The ‘analysis’ worksheet displays the last months figure, and charts the history...

Hi I have a several graphs each showing 24 series of data. As the colours begin to repeat themselves it is difficult to tell which series is which. I would like to have the series name on the chart itself - perhaps by the first data point. I have tried adding text boxes but this is tedious...