Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

Reply To: Regarding Excel

#64791
Belinga
Guest

Rex you know good info. I need some help with excel but need to know how drive test data in excel columns (L – AC) with headings (below)can be turned into pie-chart

BCCH1 BSIC1 RxLev1
BCCH2 BSIC2 RxLev2
BCCH3 BSIC3 RxLev3
BCCH4 BSIC4 RxLev4
BCCH5 BSIC5 RxLev5
BCCH6 BSIC6 RxLev6

Data for BCCH1 BSIC1 RxLev1 looks like this:

BCCH1 BSIC1 RxLev1
717 14 -67

I want pie chart show eg BCCH 717 is common in an area not matter it be position BCCH1 or any other position up to BCCH6.

Do I need to format columns/cells for this?

Please if you can help, thanks in advance