How to define a charts range based on the value of a cell

C

chris

Hi is this possible?

I want to create a graph and have it automatically ajust its range based on
a value of a cell.

I have 2 columns of data which are calculated and are x enteries long but
some of the latter enteries do not make sense and I want them to be
discounted in the graph. I know the maximum range and it is easy for me to
have an autometed cell which has the specific end range limit.

sorry if I am explaining this badly

for example I have 10 enteries but only 8 are correct I have a cell which
has the value 8 stored in it. Is there a way to say plot a0 to a(value of
cell) vs b0 to b(value of cell)

I really appreciate the help
 
C

chris

If this isn't possible is there anyway I can get the same results? e.g. write
a macro to create a new chart based on the cell? also is it possible to add a
button to a sheet which would run this macro so i could distribute the
spreadsheet and still have it function?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

to split the cell containt 1
conditional formatting based on the value of another cell 8
Trying to run excel vba code when cell value changes from empty to entered value. 1
Hide and Show Rows based on Cell Value 2
Conditional Format a range based on 1 cell 1
Q: Named range based on cell value? 3
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Top