ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Chart help on a not so typical spread sheet (https://www.excelbanter.com/charts-charting-excel/231447-chart-help-not-so-typical-spread-sheet.html)

Andrew Arens

Chart help on a not so typical spread sheet
 
I am making an aircraft weight and balance sheet and i need to be able to
chart data. Unlike normal excel sheets, i need both the horizontal and
vertical axis to plot points. For example i have two values 101 and 2400, i
need the chart to go up from 101 and put a point on 2400. Does anyone think
they can help?

Andy Pope

Chart help on a not so typical spread sheet
 
Hi,

That would be a scatter chart. If you need lines to go from the data point
to the x and y axis then add minus Error bars at 100%

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Andrew Arens" <Andrew wrote in message
...
I am making an aircraft weight and balance sheet and i need to be able to
chart data. Unlike normal excel sheets, i need both the horizontal and
vertical axis to plot points. For example i have two values 101 and 2400,
i
need the chart to go up from 101 and put a point on 2400. Does anyone
think
they can help?




All times are GMT +1. The time now is 11:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com