Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 236
  • Last Modified:

Excel 2003 Make Graph on changing table

Hi All,

I have a chart that is list a bunch of suff (obviously).  I have a visual basic script that filters this data down to four rows....

I then have a graph that is based on the current four rows.

My problem is that the rows may never be the same.  So I can not write something like:
    ActiveChart.SeriesCollection(2).Values = "='results'!$B$32:$B$35"

because the rows may be showing rows 131-134...

So my question is, is there a way to put the values of a series based on an updated table.. wonder if this makes sense...
0
sporenza
Asked:
sporenza
  • 2
1 Solution
 
sporenzaAuthor Commented:
I have tried:

    ActiveChart.SeriesCollection(1).XValues = "=results!R2C1:R5C1"

This does not work either....
I get the error "Invalid Parameter"
0
 
sporenzaAuthor Commented:
Actualy

ActiveChart.SeriesCollection(1).XValues = "=results!R2C1:R5C1"

Works but it is still A2:A5,

I want the first 5 visible rows...
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello sporenza,

Excel will normally not plot data that is filtered out. In the attached file, the chart is built on all data in rows 1 to 13, but a filter is applied. Only the three visible rows are showing.

Click the chart, then click Tools - Options - Chart tab and tick "Plot visible cells only". This is independent of any VBA code, so, in your code you can simply address the whole table.

cheers, teylyn
Book1.xls
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now