Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 20th 09, 02:58 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: May 2009
Posts: 1
Default 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?

  #2   Report Post  
Old May 20th 09, 03:16 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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?




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
need to make 4 typical entries regularly in excel sameer adhikari Excel Worksheet Functions 3 February 23rd 09 12:01 PM
Pivot Table Typical example Sandeep Jangra[_2_] New Users to Excel 2 October 16th 08 02:06 AM
Typical Problem vijaydsk1970 Excel Worksheet Functions 5 March 24th 07 09:53 PM
how do i enter a bull call spread into the options spread sheet ? alvin smith Excel Worksheet Functions 0 November 27th 06 02:23 AM
Typical excel interviewing questions Interview Excel Discussion (Misc queries) 3 July 14th 05 11:10 PM


All times are GMT +1. The time now is 02:48 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017