Adding Animation to a Chart

  • Thread starter Thread starter fiset
  • Start date Start date
F

fiset

Ok, this is an odd one.

I've been asked to look into the possibility of adding animation to
chart. Specifically, we've got a standard line graph and want to add
"stoplight" that lights up "green" if the data is a certain value
"yellow" if the data is a certain value and "red" if the data is
certain value. I guess the idea is that someone will then be able t
quickly look at the stoplight to get a quick read on the data value.
Personally, I don't know why its so hard to just look at the graph t
get the information but I only do what I'm told! So....any ideas
 
Hi!

Have you looked at Conditional Format?

Using this you can get a cell (or several) to light up in your chose
colour according to the value in some other cell. OK: Excel only check
the cell you want to format for _its_ value, but it can be fed from th
original cell and its text can be made invisible by judicious choice o
font colour to match cell colour - even when that changes.

Al
 
Thanks Alf. That gets me halfway there. Now, is there any way to
transfer the colors I set using the Conditional Format to my line
graph?
 
Hi!

Not to my knowledge (but this is finite and fairly small).

Excel has a (to my mind trivial) capability to draw the differen
sections of a single line graph in different colours - like it doe
different coloured sectors in pie-charts. But I'm not aware that yo
can control this.

Sounds like you'd like to do some sort of thermometer job on the line
paint it redder if things get hot, etc.

I'd be delighted to have a routine that did just that.

I don't think I'm up to tackling it in VBA, but I guess (story of m
life) if I can think of it somebody's already done it.

Al
 
Thanks for the time, Alf. I've been playing around with it and I can
manually change the color of values in a line graph and its not all
that big a deal but I was hoping to find a way to have the color change
correspond with the value change that happens in the spreadsheet.

Oh well, at least I can Conditionally Format the color of the cells in
the spreadsheet automatically (thanks for that) and then just manually
change the value color on the line graph by selecting the value and
then clicking on "Format Data Values.".
 
Here is an idea...Draw your three different stoplights in excel. On
red, one yellow, one green. OK, I don't know how but next you woul
need to create a macro that says if this than copy and paste th
relative stoplight into the graph. Your macro could be set to run o
startup and just make sure that it pastes over the previous one. Th
tricky part is the macro itself, which I don't even think is tha
tricky
 
Interesting idea Scott. I'll play around with it and see what I ca
come up with. Thanks for the suggestion
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Format for an object 1
Condtional Formatting, Cell Upon Cell 3
summarizing conditional formats 5
Formatting cell based upon values w/in a selection 1
Creating a chart with varying data value ranges 1
Linking MS Project Data into Excel Worksheet 3
Sorting Chart 2
Bizarre chart behaviour when changing axis cross at points 2

Back
Top