View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Avinash Shukla Avinash Shukla is offline
external usenet poster
 
Posts: 4
Default conditional formatting of bar graphs

DEAR,
U CAN PLOT A GRAPH 3 AXIES WHICH IS IN EXCEL ALREADY & KEEP THIS GRAPH ON
ANOTHER SHEET,THEN SAVE IT & THEN IF U JUST CHANGE THE VALUE ON FIRST SHEET
YOUR GRAPH AUTOMATICALLY CHANGES IN SECOND SHEET (BUT U HAVE TO DESIGN THE
GRAPH (TYPE OF THE GRAPH) EARLIER

THANKS
AVINASH

"Stacey" wrote in message
...
I have 3 columns of data: Manager, specialist indicator, sales growth
(columns A,B,C). I want to put a bar graph together to show the sales
growth
by manager and make the ones with the specialist indicator = "Y" a
different
color. Can I do this automatically or will I have to do this manually
each
month I run this report? Thank you.