Select Specific Data From Cells For A Chart
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?
|