I thought this would be simple at first but...
I have 2 columns.
The first lists Stations. ie. 0+00, 2+00, 6+00.
For those not familiar with stationing it is just a measurement - (0ft,200ft,600ft).
The second lists elevations. ie. 1600, 1620, 1680
I need to plot a line chart to represent the 2 columns, but it has to be to a scale. ie.
Vertical Scale: 1" = ?'
Horizontal Scale: 1" = ?'
Excels' line chart gets me close but it does not scale correctly. Can anyone point me in the right direction here?
I have 2 columns.
The first lists Stations. ie. 0+00, 2+00, 6+00.
For those not familiar with stationing it is just a measurement - (0ft,200ft,600ft).
The second lists elevations. ie. 1600, 1620, 1680
I need to plot a line chart to represent the 2 columns, but it has to be to a scale. ie.
Vertical Scale: 1" = ?'
Horizontal Scale: 1" = ?'
Excels' line chart gets me close but it does not scale correctly. Can anyone point me in the right direction here?