Conditionally Format Charts? 2

[Freckles]

I am charting three types of data: Actuals, original forecast and current forecast. If I use three different series, then the months without actuals have a space between original forecast and current forecast (only original forecast is showing when actuals are present). By using an if statement, I can get down to two series (original forecast and actual/current forecast combined), but when the current forecast is showing, it needs to be different color, etc.

How can I conditionally format a chart's colors? For instance, (if X = 7, format data series "red upward wide diagonal", format data series "gold solid&quot

I know that is not the correct terminology, but should make my problem understandable (I hope). And I do need what I would need to put in for "red upward wide diagonal".

: Deb Koplen
deb.koplen@verizon.com

A person can stand almost anything except a succession of ordinary days.

 

[DaleWatson123321]

Hi Deb,

As no one has yet "taken up the challenge", I thought it might help if you offered to email a copy of your file - to make the challenge easier to conceptualize. Naturally, remove "actual" data with "dummy" data if necessary.

"No guarantees", but I would be willing to take up the challenge.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[logius]

It would be good if you can figure this one out, Dale. I've been watching this thread because I'll need to do something very similar in the immediate future.

 

[Freckles]

On its way to Dr. Watson! : Deb Koplen
deb.koplen@verizon.com

A person can stand almost anything except a succession of ordinary days.

 

[Freckles]

WOULD YOU BELIEVE!!!!

First, Dr. Watson has been so nice to tackle this "mess".

By accident, when trying to describe what I wanted and give an example, I solved it myself by changing the order of the three serieses (? all the series). : Deb Koplen
deb.koplen@verizon.com

A person can stand almost anything except a succession of ordinary days.

 

[logius]

Yeah, that works, unfortunately, I'd wanted to do the same thing with a Stacked Area Chart. This method doesn't work on that.... and that bites. =(

 

[DaleWatson123321]

To "logius",

In reviewing this thread, it occurred to me that the file I had worked on for "Freckles" involved creating potential solutions - which turned out NOT to be appropriate for HER, and I (and she) came to that same realization.

However, depending on YOUR situation, the solution (involving "IF" conditions) might possibly work with your particular situation.

If you'd like me to take a look at your graph, I'd be willing to try to "adapt" my "workaround solution" to suit your situation.

If you have any sensitive data, simply replace it with "dummy" data before emailing it.

Regards, ...Dale Watson ...dwatson@bsi.gov.mb.ca

 

[logius]

Actually, I came up with a solution on this one. It's not pretty, but it works. The situation was that I was creating Burndown charts (actual data with projection data associated with it) using a Stacked Area chart. Problem was that the projection data was being thrown on top of the actual data and not beside it. Well, I got past this by throwing in dummy data that was zeored out so the two would meet up. The data looked kind of like this:

Actual: 15 12 16 15 13 10
Projected: 0 0 0 0 0 0 -2 -1 -1 -1

So I took the Projected data and created a new row of Calculated data.

Calculated: 0 0 0 0 0 0 8 7 6 5

Then, I just added the calculated data to the chart. Only trick was I had to do them in a certain sequence. Had to make sure to group the actual with the calculated.

 

[DaleWatson123321]

logius,

Thanks for your solution. Possibly other Tek-Tippers will want to keep this for future reference. It actually looks similar to the "workaround" I had developed and referred to.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca