series collection

  1. M

    Editing a filtered Chart Series using SeriesCollection

    I'm trying to write backwards compatible code to allow me to access a filtered series on a chart without using the FullSeriesCollection (available 2013 +) object. However, the normal SeriesCollection object doesn't have access to series that have been filtered out of the chart. Is there a way...
  2. nancmadi

    How Do I Get Help VBA Error

    Hi... I am new to this site.. and posted a question back in June.. I haven't gotten a single response... how do you get help on these Forums? My thread was called "Method Axes of object Chart Failed" There were 49 views.. maybe others have the same issue and looked for resolutions, I don't...
  3. nancmadi

    Method Axes of object Chart Failed

    Hi using Excel 2016, familiar with VBA but still a newbie.. I am 100 graphs in one sheet tab.. so I am looping two sub routines to give names to the legend & Axes Titles I ran this code to update Legend Titles and Axes Titles... Legend and Primary Title updated fine, but I am getting 'Method...
  4. J

    Data Labels: Label each point with value next to x value

    I'm trying to create custom data labels for my XY scatter. The range of my data is variable as I have an auto filter macro which changes with each set of data. I want every data point to have a label which takes the value 2 cells to the left of the x value. For example, if I have a point with X...
  5. Drofidnas

    Retain colours in Pie Chart with Dynamic Range

    Hi I have a dynamic range which populates a pie chart with up to 5 values: Not Started - blue Complete - green At Validation - orange Overdue - red In Progress - yellow If any of the values are zero, the range contracts so I don't get a null slice. Basic stuff. What is happening though is...
  6. S

    Series line not correct after split

    I'm using this code to split a series line into 2 overlapping parts, so I can use different styles on them: Sub backfillDataSeries() 'make new series in Port Historical Risk 'if there is a backfill date in Rolling window data Dim cRange As Range Dim i As Integer For i = 3 To 122...
  7. S

    Stumped... Looping through chart series collections..

    So... This code was working fine, but now it's not... I am a little stumped.. It works A-OK if there is only 1 chart visible on the worksheet, however if I have 2 charts visible the code stops removing the desired series collection.. Dim SeriesNum As Integer, CurrSeries As String, i As...

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
Back
Top