Hi,
1] I am trying to create an XY Scatter chart and align the 4 corners of its plot area to the 4 corners of a background picture so that the chart axis points meet the background pics corners correctly. The chart X & Y axis should not be visible.
2] I want to delete & create the chart(NOT THE BACKGROUND PIC), everytime i click the "CreateChart" Button.
3] The source data table for the chart whould be in blocks (POT) like this:
BLOCKQUOTE
Attr Sal POT# PAN# POT-PAN Pair
78 97 1 1 1.1
67 55 1 2 1.2
43 65 1 3 1.3
55 12 1 4 1.4
33 34 2 1 2.1
75 65 2 2 2.2
26 34 2 3 2.3
37 54 2 4 2.4
32 78 2 5 2.5
87 66 3 1 3.1
44 56 3 2 3.2
88 12 3 3 3.3
89 14 3 4 3.4
12 0 3 5 3.5
0 0 4 1 4.1
0 100 4 2 4.2
100 0 4 3 4.3
100 100 5 1 5.1
15 10 5 2 5.2
56 23 5 3 5.3
98 89 5 4 5.4
/BLOCKQUOTE
the data points for X-Axis: Attr Column
the data points for Y-Axis: Sal Column
4] POT column shows the groupings. Altogether 5 groupings. so there would be 5 Series names. Hence each group of data series & data labels would have similar color.
5] The data series name would be from column POT-PAN Pair.
1] I am trying to create an XY Scatter chart and align the 4 corners of its plot area to the 4 corners of a background picture so that the chart axis points meet the background pics corners correctly. The chart X & Y axis should not be visible.
2] I want to delete & create the chart(NOT THE BACKGROUND PIC), everytime i click the "CreateChart" Button.
3] The source data table for the chart whould be in blocks (POT) like this:
BLOCKQUOTE
Attr Sal POT# PAN# POT-PAN Pair
78 97 1 1 1.1
67 55 1 2 1.2
43 65 1 3 1.3
55 12 1 4 1.4
33 34 2 1 2.1
75 65 2 2 2.2
26 34 2 3 2.3
37 54 2 4 2.4
32 78 2 5 2.5
87 66 3 1 3.1
44 56 3 2 3.2
88 12 3 3 3.3
89 14 3 4 3.4
12 0 3 5 3.5
0 0 4 1 4.1
0 100 4 2 4.2
100 0 4 3 4.3
100 100 5 1 5.1
15 10 5 2 5.2
56 23 5 3 5.3
98 89 5 4 5.4
/BLOCKQUOTE
the data points for X-Axis: Attr Column
the data points for Y-Axis: Sal Column
4] POT column shows the groupings. Altogether 5 groupings. so there would be 5 Series names. Hence each group of data series & data labels would have similar color.
5] The data series name would be from column POT-PAN Pair.