jaypee said:
im making a report and i want to insert this data in the chart but only top
3 highest value in jan feb mar and apr will see in the graph.
how can i do that?
jan feb mar apr
A 23 3 5 5
B 1 3 1 5
C 4 1 0 34
D 16 2 2 2
E 3 14 4 1
F 4 5 3 0
You need to do a sort. If you need to retain the original order,
do the following.
- Insert a new column between jan and feb, between feb and mar,
and between mar and apr.
- Copy the first column into these new columns.
- Sort each month's data, being sure to include the column beside
it that has the letters. This will let you keep the letter beside the
same value each time, and will let you return to the original order.
For example, the apr columns will look like so
apr
A 5
B 5
C 34
D 2
E 1
F 0
and finish so.
apr
C 34
A 5
B 5
D 2
E 1
F 0
If you need to return to the original order, you can
sort each month on the letters column.
- Graph the first three values in each month.
Alternatively, copy your data to a "work" area, and
sort it there without the extra letter columns. Sort
each column by itself, then graph the first three vals.
That way, your original data is not changed.
Socks