39461_en-US

liliconcom

add line and label axis by extracting formula into the chart

Hi,

I cannot sucessful add the line and label the line into the charts.
Can anyone give me some hints on how to add the line and label the line into the charts?

 

Thanks.

Re: add line and label axis by extracting formula into the chart

What you need to do is to generate the chart you want interactively, then add the reference lines you want.  Once that is done, then simply go to the red triangle and select

     Save Script==>Script Window

It will show you exactly the script you will need to produce the chart and the reference lines.

You can also go to

     Help==>scripting Index==>Add Reference Lines

and it will give you the definition and an example of how to add the reference lines.

Re: add line and label axis by extracting formula into the chart

thanks @markbailey for replying. I gain new knowledge for using the features.
But now i want use script to script out the line and label the line into the chart.
I have try lot of times to add and label line, but it still cannot successful.

Re: add line and label axis by extracting formula into the chart

Right-click on the axis and select Axis Settings. Notice the Reference Line area in the lower right corner of the dialog. You can add as many lines as you want. Each one is plotted at a given value, label (optional), color, opacity, and line style. Remember to click Add for each definition. Right-click on the axis again when you have the desired result and select Save to Column Property. The Axis column property will assure that this data column will always be plotted this way from now on.