View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Env shah
 
Posts: n/a
Default Pivot Chart which shows average line with below and above figures

Hi ..

i 've following data in pivot tables .

executive name % achievement
ABC 70
XYZ 20
PQR 55

I would like to make pivot chart which shows first average (horizontal
line ) at 48 % and below it shows XYZ ( 20%) ...And above average
line it shows...
two names of ABC ( 70%) AND PQR ( 55%) .


--
Env shah