Error more 255 series in the chart

  • Thread starter Thread starter Carlos
  • Start date Start date
C

Carlos

I have a scatter xy chart whit xValues and Value switch via code with
series.formula properties ( thank's Jon Piltier)

the data is time values, the column A is Series Name , Row 1 is chart scale
(Column E is a next time of a serie with same name)

A B C D E ««« Column
0,1 1,9 1,9 0,1 ««« yScale Row 1
1 6:00 6:01 6:03 7:05 ««« xScale Row 2 Serie1
2 6:15 6:16 6:18 7:20 ««« Row 3 Serie 2
4 6:25 6:26 ... 7:30 Serie 3
7 6:45 ... ... ...
1 7:05 ... ... ...
2 7:20 ... ... ...
4 7:30 ... ... ...
7 ... ... ... ...
1 ... ... ... ... more Rows

The question, it's possible join all series with same name, in this case
with 4 series(1,2,4,7) with same disposition of data? How?

Thank's
 
Carlos -

Try a pivot table. I adjusted the header of your data like this:

Row Name 1 2 4 7
4 1 6:00 6:01 6:03 7:05
5 2 6:15 6:16 6:18 7:20
6 4 6:25 6:26 6:30 7:30
7 7 6:45 6:55 6:59 7:45
8 1 7:05 7:13 7:20 7:30
9 2 7:20 7:33 7:40 7:55
10 4 7:30 7:45 7:55 8:20
11 7 7:45 7:55 8:00 8:30
etc.

The column "Row" has the formula =ROW() in each cell, and is used in the
PT to produce many distinct values, rather than summing or averaging a
bunch of them together.

I selected this data, and constructed a pivot table (Data menu) using
the Name field in the Column area of the PT and the Row field in the Row
area. I put Average of 1, Average of 2, etc, into the Data area. You
can remove the grand totals, and use a time format for the cells.
Finally, add a column for the Y values.

The pivot table looks like this:

name
Row Data 1 2 4 7 Y
4 Average of 1 6:00 0.1
Average of 2 6:01 1.9
Average of 4 6:03 1.9
Average of 7 7:05 0.1
5 Average of 1 6:15 0.1
Average of 2 6:16 1.9
Average of 4 6:18 1.9
Average of 7 7:20 0.1
6 Average of 1 6:25 0.1
Average of 2 6:26 1.9
Average of 4 6:30 1.9
Average of 7 7:30 0.1
7 Average of 1 6:45 0.1
Average of 2 6:55 1.9
Average of 4 6:59 1.9
Average of 7 7:45 0.1
8 Average of 1 7:05 0.1
Average of 2 7:13 1.9
Average of 4 7:20 1.9
Average of 7 7:30 0.1
9 Average of 1 7:20 0.1
Average of 2 7:33 1.9
Average of 4 7:40 1.9
Average of 7 7:55 0.1
10 Average of 1 7:30 0.1
Average of 2 7:45 1.9
Average of 4 7:55 1.9
Average of 7 8:20 0.1
11 Average of 1 7:45 0.1
Average of 2 7:55 1.9
Average of 4 8:00 1.9
Average of 7 8:30 0.1

Now select a cell that isn't touching the pivot table, and start the
chart wizard. On the Source Data step, click on the Series tab, and add
the first series. Click in the Name box, then select the cell in the
top of the pivot table (1, 2, 4, or 7) for the series name. Press tab,
and select the column of data below the name cell for X, then press Tab
again, and select the last column for Y. Add the other three series in
the same way.

As data is added, you'll have to add more to the Y column, and adjust
the length of the charted series (the length of the column being used).
You can use a dynamic range to determine the length of the ranges,
however, simplifying some of the process.

- Jon
 
You are the best, thank's.
With your approach, i try to find a way the write the code for this.
Thank you one more time.
 
Back
Top