series name

  1. S

    Extract Unique Series Names and Add as Dummy Series

    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...
  2. D

    Command Button : Add/Remove data series

    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.)...
  3. S

    Line chart with data in one column and series in another.

    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...
  4. Grizlore

    Charting from a Pivot table, losing series values. (named range possible?)

    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...
  5. C

    Put Series Name On Chart

    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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top