I create an excel spreadsheet by "poking" values through to excel from another program. The number of rows of data is variable. I then need to plot a graph using this data. Whenever I try to select and plot an entire column, the chart goes "pear shaped". So I thought I would work out the number of rows using a function such as counta(column). I could then use this to create a range address (Eg ="Sheet1!A1:A" & Counta(Sheet1!A:A). That works fine and I get the correct range. The next problem is using this in a chart. Where it asks you what you want to plot I wish to be able to use this range reference. Does anyone know how I can get the chart wizard to see the data in the cell as a cell reference? Thanks for any help.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to reference a cell with a range for charts
- Thread starter Stoffel24
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question