T
tcolan
Hello,
I don't know if this is possible in excel 2000 but I figured I woul
ask a quick question instead of continuing to spin my wheels on it. I
there anyway to automatically conditional format the color of a pie o
bar chart. In other words, I have a table of data that is going t
change from month to month. The table I am graphing looks like this:
Project Size Status
Project A $2m Green
Project B $.5m Green
Project C $1.2m Red
The number of projects and status' could change from month to month.
want to create a pie (or bar) charts that will auto format the color o
each piece of pie (or bar) to the status color. Is this possible?
Thanks for your help,
To
I don't know if this is possible in excel 2000 but I figured I woul
ask a quick question instead of continuing to spin my wheels on it. I
there anyway to automatically conditional format the color of a pie o
bar chart. In other words, I have a table of data that is going t
change from month to month. The table I am graphing looks like this:
Project Size Status
Project A $2m Green
Project B $.5m Green
Project C $1.2m Red
The number of projects and status' could change from month to month.
want to create a pie (or bar) charts that will auto format the color o
each piece of pie (or bar) to the status color. Is this possible?
Thanks for your help,
To