how do i hide a series in a graph with VBA code

**kevinu** · 04-23-2018, 04:01 PM

I'm trying to hide a series in a graph. I can already hide a category but the series is tripping me up. So far I'm using the same code as the category but renaming it to series but its not working. I'm using

Please Login or Register  to view this content.

Im getting an error 438

**AlphaFrog** · 04-23-2018, 04:32 PM

Try something like this for a line graph...
ActiveChart.ChartGroups(1).SeriesCollection(1).Format.Line.Visible = msoFalse

Another trick is to just hide the data column for the series e.g.; if SeriesCollection(1) is data from column B...
Columns("B").Hidden = True

**kevinu** · 04-23-2018, 04:56 PM

Thanks that worked great

Does the .isfiltered not work with the series as it does with category? Just curious why my original didnt work.

**kevinu** · 04-25-2018, 12:02 PM

In case anyone wants to know i found out how to filter instead of hide. Code should look like this for series,

Please Login or Register  to view this content.

how do i hide a series in a graph with VBA code

LinkBack

Thread Tools

Rate This Thread

Display

how do i hide a series in a graph with VBA code

Re: how do i hide a series in a graph with VBA code

Re: how do i hide a series in a graph with VBA code

Re: how do i hide a series in a graph with VBA code

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Color Formatting of Graph Series (via Graph Series Label)

[SOLVED] Move from one series to the next series in a graph shortcut

[SOLVED] Second Axis for a Graph but with the same kind of graph for the two series?

varied series for graph which adjusts series

Show/Hide series in a graph

Two Series Graph-Add Line Graph To It?

series graph -- one series being added to another series

Bookmarks

Bookmarks

Posting Permissions