Automation Of Charts

[Scott Black]

I'm Hoping Someone Has Solved This Small Issue And Can
Help Me Out. My Company Is Currently Working With Excel
2000 To Create Line Graphis To Better Explain Power
Comsumption. While The Chart Generation Is Relativly Easy
To Do, We Have To No Way Of Automatically Placeing "DRAW"
Figures On The Grapic At Specific Times/Events.

Example: A Large Scale Machine Starts At 10:42am, And On
The Power Comsumption You See The And Increase In
Comsumption. I Need To Be Able To Have Excel Read From A
Worksheet That X-Device, Started At X-Time And Plot It On
The Graph. Is This Even Possible? I've Been Doing It By
Hand. But It's Turning Into Hours Of Work. Any Help
Would Be GREATLY APPRECIATED!!

Scott Black

[Jon Peltier]

Scott -

Is the "X-Device" a graphic object? Here's how to do this.

Set up a one-point data range on the worksheet, with the chart coordinates
where you want the graphic to be positioned. Plot this point as its own
series, as an XY Scatter series on the chart. Copy the graphic object from
where you've embedded it on the worksheet, select this brand new series, and
press Ctrl-V to paste the graphic as the data marker for this series. After a
few minor tweaks, you'll know how much to offset the data point from your true
data to get the effect you desire. Then you can have Excel chart this new
series automatically. Record a macro while you copy the graphic and paste it
onto the chart, and you'll see how to make Excel do this automatically.

- Jon
_______

In article <ca8d01c212ad$8e4c1c30$36ef2ecf@tkmsftngxa12>, res0...@gte.net
says...