View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default 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?