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.
|