Select Specific Data From Cells For A Chart


D

Dave

I have a spreadsheet that has a row that I want to use as a data range in a
chart. The cells in the row contain three numbers on the left and three
letters on the right. I can select just the three numbers by using
“LEFT(A1:Z1,3)â€. How do I use that formula to select just the three numbers
for the data range in the chart?
 
Ad

Advertisements

L

Luke M

Note that your formula is incorrect in what you think it does, the LEFT
function cannot reference a range of cells.

To reference the first 3 cells in a row:
=OFFSET(A1,,,,3)

To reference cells C1:E1 would be:
=OFFSET(A1,,2,,3)
 
D

Dave

Well it looks like the LEFT command can’t be used for a range of cells. But
what I need to do is basically capture the first three charters in the cells
(numbers) and ignore the last three (text). And use only the numbers for the
data range in the chart.
 
J

Jon Peltier

Don't try to be clever and use the original range in the chart. You're
going to have to use a nearby range to hold the values to be plotted.
Use whatever function you need in this range to extract the numerical
values from the original range. Then plot this new range in the chart.

- Jon
 
Ad

Advertisements

D

Dave

Jon,

Thanks, I though I might have to do that.

Jon Peltier said:
Don't try to be clever and use the original range in the chart. You're
going to have to use a nearby range to hold the values to be plotted.
Use whatever function you need in this range to extract the numerical
values from the original range. Then plot this new range in the chart.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



.
 

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

Top