Charting data as 'boxes'

  • Thread starter Thread starter John Phillips
  • Start date Start date
J

John Phillips

Hi All

I have an x-y chart (y is a date axis) and a series of
events happening along the x-axis. The x-axis is the
position along a datum, and I'd like to show a 'box'
starting at one x value through to a second x-value to
define where the event is happening; then the top and
bottom of the box define the start and finish dates.

I can store the data in a table easily enough,
[ID;Startx;Endx;Starty;Endy] but is it then possible to
use it to define the four corners of a box and get it to
draw a series of 'boxes' on a chart ??

Hope this makes sense !
Regards
John P
 
John -

You could draw a rectangle in an XY Scatter chart using this data:

ID
Xstart Ystart
Xstart Yend
Xend Yend
Xend Ystart
Xstart Ystart

Copy this 2 x 6 range and use Paste Special from the Edit menu to add it
to you chart as a new series, Name (ID) in first row, and categories in
first column.

- Jon
 
Back
Top