S
surftesh
Is there a way to create a chart that uses data (range)
from multiple worksheets in both x and y axis. In my case
I have several worksheets for different cities in one
file. Within each worksheet are three columns. Column 1
identifies a point of interest in the city, column 2
measures the distance from the airport to said point of
interest and column 3 has the elevation of the point of
interest.
I wish to chart the distances on the x axis and the
elevations on the y axis using the data from the each city
worksheet directly without creating another worksheet that
references all the data.
from multiple worksheets in both x and y axis. In my case
I have several worksheets for different cities in one
file. Within each worksheet are three columns. Column 1
identifies a point of interest in the city, column 2
measures the distance from the airport to said point of
interest and column 3 has the elevation of the point of
interest.
I wish to chart the distances on the x axis and the
elevations on the y axis using the data from the each city
worksheet directly without creating another worksheet that
references all the data.