Conditional Formatting in a Chart

[szimmer661]

Does anyone know of a way to conditionally format an entry in a series on a stacked bar chart? I've seen MrExcel podcast #444, but don't think that solution utilizing a secondary axis will work with a stacked bar chart.

 

[pgc01]

Hi
Welcome to the board

Not enough information.

Please explain what is the conditional formatting you'd like to have. What would be the conditions to trigger it and how would the series be formatted ?

 

[szimmer661]

I am gathering information, start time, end time, etc. on jobs running on our mainframe during our nightly batch window and presenting that information as an elapsed time and the start time as a time after 20:00, the start of our batch window. I also have indication on whether there was an error running the job. If there was an error, I'd like to selectively have that job's elapsed time bar on the chart show a different color than the others in the series.

Thank you for the help.

Regards, Steve

 

[Steve=True]

Yes you can do this.

I would have a separate chart area instead of the original data.

Then in your chart area, check to see if it was an error. Something like this:

This is your chart data for all the regular points
=if(data<>"error",data,na())

This is the chart area for the series that you want to make Red
=if(data="error",data,na())

Chart it all and then reformat the Red series with a different chart color

Repeat for each section.

na() is your friend in this case.

Steve=True
www.exceldashboardtemplates.com/about

 

[pgc01]

Hi Steve
Welcome to the board

Here's another idea.

With the table with the job start, end and error flag in A2:D8, you build an auxilliary table in F3:I8.

In G3: =B3
In H3: =IF(D3,0,C3-B3)
In I3: =IF(D3,C3-B3,0)

Copy down

Now create a stacked bar chart based on F3:I8.

- make the first series invisible
- paint the second series with green
- paint the third series series with red

In this example I set Min for X 0:00, Max 7:00 and Major Unit 1:00

Remark: this is just an example, you have to adapt it to your case.

The data I used for this example:

<table border="1" cellpadding="1" style="background:#FFF; border-collapse:collapse;border-width:2px;border-color:#CCCCCC;font-family:Arial,Arial; font-size:10pt" ><tr><th style="border-width:1px;border-color:#888888;background:#9CF " > </th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" width=30 >A</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" >B</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" >C</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" >D</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" width=30 >E</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" width=30 >F</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" >G</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" >H</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" >I</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" width=30 >J</th></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>1</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>2</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Job</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Start</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">End</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Error</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>3</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Job1</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">00:00</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">01:00</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:center;border-width: 1px;border-color:#888888; ">TRUE</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Job1</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">00:00</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">00:00</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">01:00</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>4</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Job2</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">00:25</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">04:00</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:center;border-width: 1px;border-color:#888888; ">FALSE</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Job2</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">00:25</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">03:35</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">00:00</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>5</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Job3</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">01:10</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">03:00</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:center;border-width: 1px;border-color:#888888; ">TRUE</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Job3</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">01:10</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">00:00</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">01:50</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>6</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Job4</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">05:00</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">06:30</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:center;border-width: 1px;border-color:#888888; ">TRUE</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Job4</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">05:00</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">00:00</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">01:30</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>7</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Job5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">04:00</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">05:30</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:center;border-width: 1px;border-color:#888888; ">FALSE</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Job5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">04:00</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">01:30</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">00:00</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>8</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Job6</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">03:15</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">03:45</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:center;border-width: 1px;border-color:#888888; ">FALSE</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Job6</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">03:15</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">00:30</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">00:00</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>9</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td colspan=11 style="background:#9CF; padding-left:1em" > [Book1]Sheet3</td></tr></table>


The chart:

<IMG SRC = "data:image/gif;base64,R0lGODlhbAJHAff/AAAAAAAAOjoAADoAOgAAZjoAZjo6ZmYAAGYAOmY6AGYAZmZmZgA6kDo6kABmtmY6kDqQ2wD//2a2/5A6AJA6OpA6ZpBmALZmALZmOv8AANuQOv+2ZoCAgJC2kJDb25Db/7b////bkP//ttv/////2////wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACH5BAEBAP8ALAAAAABsAkcBQAj/AAEIHEiwoMGDCBMqXMiwocOHECNKnEixosWLGDNq3Mixo8ePIEOK1FiipMmTKFOqXMmypcuXMGPKnEmzps2bOHPq3Mmzp8+fQIMKHUq0qE6BRmsCSMq05NKmTJ9CLSp16tCqVoNizQp0K9eeHLR6/eqUrFazZ9H6HKvWJtu2NN/CnSl3LsywXeuqDFEAxMoLElCSmAAgwAeXeu22TKyYJePGKR87jUC5suXLmDNrjiC5RGfIZUG7FV0T70+kMjcINFxSxAEABPyWuLCg8OESrmHLdkw6bm/fv2N2BrC5uPHMw4MLV76cuUvTaz9TdY6YenXrK6VD1t6Ye3fsK6H3/0Q917td8+fBq0QPl31b9+/VpxTPk3x7+Sjhq9Vvlj9Z/18BGCB+J9G3k33xERiagp4x2CCDI0UoIUJROWjgUZ/x5dcFEJSwAQMjzAaihrkJFNhiDgrIlYpWsTgVccfFKOOMNNZoo2YuPqjghTkhuF+KDupIYI5NwXjjkUgmqSRyFTLII04+okVkkxACWeWVWBL45E1RZlWQlVniN2VSYxpVppkWiqXYmUSx2SaYQ8IZp5NqphemmHLK56ZQAGTg55+ABirooIQWauihiCaqaKE5bukWYyIgcNiHIXLoIYizOVCChiYNdiJvd+qZp3p7arXoqaimquqqjDLlqFKlrhw3KqmzYhfraUHe6tOrcel6kq/15VqrdcAeKCyd/3mtOSyxyzpX7FHH7lhnec06W61yz/YYrZbTzsRpbrGVRJuJKHEKqoJ19cnquuy26y672UJ5LbZpJmsnui+p++6+/Pa7b7xczhscwDbxStezBCu1LZ6hgpewwsiehrDAvz1MF8WkWXxxxNEp27DDGIumcXMfW2ewTF3+x+eSLLfs8sswxyzzzEeODJPNN9crsU0kKuBXpIcBVoKnmwrwKYpa0az00kw37fTTNYcsss4d3yvxhFhnrfXWXHckNWg4P9dtgvh+/V3J1IV9nbT2Uot22mZ7XPbbzJ0s3MR0M6f2uXPO7Td+dt+cYV9/HV2SauEu5u/iiu7NN8N/ixq3XYeB54sw45gb6nh2k7sdueRs72w15J+DnPfAC8tXOWJ4l26668yejjrH420e5O2456777rinHFRumOL2WvAmAR+i8AAQ/5XxJ5lb/PDHM4+W9CEIQO5J0ktPlvSq6YZS9tBPH36nExgOfvLHbz++BgMl3tr42quPfkmD2fY9/OPLjyn7BB19vvL/loPK/0L0LfzNzyzx41QBDxi/5YWPfwORwAKD18CsSI9/rJlg9PLnwAPSr3ybItwAxXdADB5Gg+/zoP426D0UIg+AFoSfpEziwgouxna8y6EOd8jDHrYIhz4MohCHSMQi/gqIRkyiEpfIRGIhsYlQjKIUp/ii1vUNdnCTXW+euCBute0+WtwixrAGMSxmMXRVo0nPfjZDoc1GgkbbVAPSJ6swZmyMTUuOHadGu/pYkXRXBOTN8ljGQApSPau7odwMCTpGvs6RjwTc2H60R7B1DoxmtFYfD/THRkIydpmk1yXbkkjHdJJWo6QkuqDGSprliIulzA6kZkip2XSolhfQZpSGakmCCuymjqEUZTAr1spiwuyVVKvdIg+JymGKsZLbSaYfl+lJZtoqlVJKHSInmU1ons2Zd/QmNbf5RbJ9EpTn1CQ4w4lGZdaEU5bC5YgIRwIKeACESFsnH/UZTQhl7p8AbVVSYv+5nlNG0proRGjaAsrQhjaKm/3BZjf5+c10qtOLopMSQSQaUXF6zqJ6kyYnx3nQajYTpLPzKFwIGhmDXhMxDY2pTFXFxZpqEzwszc/gQCACn+GmjYEh2kncyLm36WumSE3qoGyqUkxiNI1OVahnukbVqn6pqaqkqGJyekSSvhSrE0VpxW6KHa6axHcr4qjKwNpRrXrVZBBdq1tHZ9KS2vWucC1nTBaYuHEBIDAb0JS4DJeflRnzsIhNrGJZyVS2ksWsTnFpjxZL2cpa9rI1auxcVxrXATlWrmJ95majqrrOpvWznh1tVqV6UUnqNaysDSlqvaTW1D7VneVRqr+4KKQ92KY0tKK97TTf2RdO1fMwGLgNUZ2XHd32i7ea9e1Ya5sVyE51Tc7lF3Sp2yLudneTGHrrGVUL27p+lbxmsf8uWmk7W/aiF7TSnS5610vF+tr3vvjNFZFqCTT+zvBwmOpvgP/LFf/eJoS/NLCBzbLgD3bIJAoe8IGz0uDqsQbCEm5wgSVcAg1AQKgADpGARUxgCks4BAM4zHExTOIPaHjDLa5eYEIwRxb/1MUc/kqDgYaSCLcYZbzNr5CHTGQo0rfISE6ykpdsWiY7+clQjnJBpUzlKlv5yUe+spa3zGUhZrnLYA6zmNEV5DGb+cxh/jKVgMtONluyvd9t53A/Gt/g1nmfbn6znEdK15PmuaJ31vN7v6JeyY73z+JdDyGBM2jbujaj3hLha/pam7/ixqc5g/OL8Mg0PTb6tHsOL3FDeepTHgvNUyJ4wI8fZ97z1tlISvM0ohNdtybHedZ9xmt2Fr2xT7tXuHymc6sTOuyCSqiQgRb0o6FqzmT309eb1jRUYP9p62hD29q4Jq2fnb3Vak/bu9jmdq5dLe65FJrWwrx2kcC9bna7ytvtVne8s93sYre2tK9tK73rve1+6/rQ+IY0v/99b3/bCrMIvwwywdujnRYOJURd275Xa29sJfzinFnzsnEbaRAYlwLIVa7hIh4Zd2u84gPDeMIXHuqGo/u3E9e3mFSOcJYDW9TCNji5dZ42mmPW5hufs7YJLlt5k8nkR2c4lAxdcJ43fedET3fQgz10qEddvjGHb7k5m2+tO/3pxP661LdOSnifXOxjRzvWyT7wspo96UaHe9YdjXKYB5zZFFf72utuZz1l9++oemjXW8LcoRK2w5bO59zprvclNosJ8JBPlOAFvtfi0hPkJUjuYGk8AhAXNe5okvbZHRb50gvUKP/nHnfYG49ntkvJ9LAP1OTxXl7Wt57vjvd77Hc/e463ffVX77vtnw16oqQ+58EXfvJvP3ziTx3nVQe+1aUP8OYD+u6+z/vymb995+M+9+SkfO27733rq7765jf320Nf/DeJXu6uH7/bBw/qdB519/hfVXS/z/35i/8lhWcSJNc97vN59pd/CKh/SDcdC2h867dGN/ZGg1USFjZhwHSACZiBi7J/6Yd8/kd7LNE9FwYusjEuF2ZCEidV96eBLLhUDXgVZJVX/+d1/7aCLXiDfsKB5Hd94QeCNDh91Ad26AeEQyiDPsh4O/hye9eBvxeEtUZ/vxZ/Msd/5ZeE5+ccxxcmfUXohGlnhVq4hVi4fgzYfjD4fuy3ePX3fC53hUVHhmnhhl0Rg9T/kYVNyCVWdYd4mId6yBEvWIYtt3Q8QzgqQXLVcz2sVh8+l4iKuIhJooNeWHZQuBd90VNsFDQnQlSD8WCHeCCM2Ime+ImY4YhE+IQzqBIieBskKC61wRoQZIgXuBagGIuymIiiyIXBQYfadxSzuIu8eFm1CIakeIRpSIVVOIpdaIzHaITZJ3+2aHdMmIvNuIQ4JYbuB4dxaIZjiIZRiH1CV4dtqI3hRoxKKI0fuIxT+IzQCIzJqI7rGIaRGI7oyIzsSI7RqHzl2I37sYcYIYdC2I/fKIWERo1XgYOEsl3YWI3gCI/T+I7lQjjxhCkXME+7EYD5QZAu2IdvmJDzppHvUcaQPIZLtwSRuiSICAZTFil7/PiP8fiDyPgbuPh6JwkoBmmNa4GRGamGgMiG7eiPO9mTzriSAcmQGymO4wh+j5iO89gbL3mOR4mUKtmUTAmVj/8lkNGhj1Z5lViZlVq5lVzZlRexlCyZlPZYj/1HlmUplgGEZmq5lmy5RWXWlnAZl0OmZjhBiQhmlxoCgXpJkhbkU/AUAB1AOHtJan5BkQLkl30RWAIoQZOImIRZksvjmM1jeY85mNsjmZtiAAkwY41ZmJ0JmVyBl32xYjT0mZZ5mZ75mKVZmabJl1YhmrvBY4MJm0DWFLBJm63hmLgZmpgJmpeWmrvJm6lZNIR1m73Zl8NpeMWjm8f5mo7ZigCgicaZnMLpmxKYm8DZnM4JnKoWgdh5l9p5mMlpKd/DnNSZlnKZnuq5nlTJnu75nnJJl/A5n/TJlvJZn/iZn112n/pC2Z/+CWVeGaACOqAEWqAGeqAIyof/uaAMup9v2aAQGqEB8qASWqEWShUUeqEauqFUx6Ee+qFExJ8gOqIk6kQleqIo/9o7ulIQHNCiLvqiMBqjMjqjNFqjNnqjOJqjOrqjPNqjPvqjQBqkQjqkRFqkRnqkSJqkSrqkMdqe10iTNXmQfsiRo3ePHeqUPvmTLTmWaHmW7liKwwiUSLilRkmmZaqM+CiPPJmlXLqm9GiWkAGWYwqnxUinRemlbqqUToorUjqlABmmUhmWXyqM2yimgEqmsOZKyEaUOnmLexqlUDoenLY0svanh4qmVwoThklyQlNLm2imeMqmnsFrKGOTT3pza6hGDhmSlSKRNGYB9qN4llqoyZeoM1OpjOqBmAp9MpGXlxdym1djPPapdnqnyjZInbaohkqrVsqrLfGREMmqmW5SkkLDebKaq1/4lItBqiRDpfDHjZkalcXaqG+qaMnKaN56hjhph8Zap+OarfnBrZkWqcGidOxKrm2ap2e6a+faa+majev6KO3Kg8uqkKDqrl0ap48qqX3KJ6YKqf+KkAELKwNbsRarqwlLsIHKFf9yeqkZq7Hv6o2iuq+Dao6Cqq0HC7Ifi6/5qhwdy6whK7JaGrNqqq+i8bJRsVENe5PYiqUzS7PptbD1Sq/GsrN8SrTQYq8Cy7KhOrLHWrDf9rBgIbRFi7TaYrQQO6u3NrG9crHw6rQIi7Iry7SggbMGC7TiOrZfW642W7ZUm7RWKy9Yy7BxGzBKS7FkG7Zi27bb0YtPA3Tg6qw1C7Z6+7PO4rdOA7g9aLKE55qLiRIQVIAlN7d0G7GGhbiUWqW7mqodhzyURi6kmS9SW7laO22Y268AG7ic26ufaWqXKEEpNjSYR6xqu7Ytm3KnG2uaO4cP2LpANTT49Li0y7eFy7ZAFpe7ivqti5umIbgaqDhpJbiKt4GC1wq1UVu3SoG8yauuqpuTGEu8Kgu+56G9t7q7Jcu8J0u44bu3ekO+MqO4C/8JpjBbuzJrvAOToF1jvsHIuB4rvnm7vur7vwDsqEKpvwEswAj8vey7wAQsv1vbsz5rvxJ8u4a7v+g7p/QbwRS8wSTrv1znwGebwYNbwQdsuxx8s297tdirrBs7vx5swihcwMrbwi7MwBPcwTaspzLMvdY7lD08wyk7wC6ZwnK7wuhauj5Mww+8vOGaviRcwvV7wk/7w6hHxHZrxP6KxAb8xFyswyB8vZbrsJRbtWHMs0wsuGn7wlGMw12cMfjLNR35xUkcxF67xk1bMTGJVL13wSyxqYfnea8IwSN8w3e8RXk8U3vcxI37M9CrioYYApp5eL8yukNbxkc7JIcsU4kwjMYuAYGuO4EeBsiTi8WlOsZwi8mZ7FBxTKiS+Jif7CnQqYmBTMU8rMRg/HipzFCb/7y6LnGKKfS5F/ZBknxWlEzGWgzExJLLurzK/FvDUGzHU0zHuaXMALXL3gvD0SzN2Fy8hkzN/2TN96rAz6zBbEzIYPPGW8PMfOzMbVzOUszN7vzOjWG2tyzIaZzD8VzI8txtO5y6tOzPtjzHaOvEQ9zPEmvPBL3PCbzN8BzDcrzF5pzNIpzQ+azPDs3KIazG5GzREq3Rg+zFGF3P/3zQIy3GpNytXHswdbzRHN3QHY3PFa2wBu2nCI3BHk3RLe3SMv3QyDzROP3S43zPMO22M23SlnzJx1zL2szQ/MzTSj3QNj3UOi3EET3PVjwaRoXOBFrMKnzSL0HPAg2GNujNpRX3i1I91U0d0mHdj2NN1pBn1kEt1A3/rNar+XB1rQGCNbx729Zu/Xdw3c45ndbN3Mq2dCmtOgLMhdcpWGx83dfO9ddVTdWkAdar+XHAep2tUWKjjIGObXqQrdALDYlfDK2VIq25hGAvttkq2Nmw99kxjdaUc9UsTISNzdp6zNVF7NViU9RmXIO2Xda4fcW63RKU3dNs/duR59qBvdJoUdxP7dNRHdfRDdhAPdeDndFnLdnLLc7UDdvqx9unmtTPfdPTHdnMHbTgjdQ13b/ZHdosXd0F7dQAvdTQ7N1M7d7vbdXpnbXrzc7mzd3/DeAgfd1morPDXb0BDdGgLeCTLdtH3N9LnODG3d74jd7yTdISPuHSzd4bLM7h1r3OEU7f+X3eP23f9/3dF07TJW3U4o3hIv7RDb7fpAvh2N3hIQ7VHh7f/3St4d2t3fC94PVt4mrh3PM9We575EhOI8q93R+84+PtFkke5VKOI8Et3Cldm6Nm15l9QrGr19k75WA+5Uv+4zHu1PBk2hKJPZpdWEkT5m6O5GMu5M3dux73q5kncu8jywYIi2/e59ob5z6+0yFN2oWNSyPpcXE0r6fh54x+uoBO4kGZ4iw+Ho1e6b346BU+lTJeyXxu6Z4OipjO4BdN4GsN5Z9+6p0Y6ife5KSu4K8d6LAO6Tke4KLt5EUO3bP+6ple3rQ+5A6exTQu0hl+6+TN62Vu6y6O4/4N5CO+68Y+6iBe4z0u68uu66LO5LXe6jze681+7XIu19OO4sh+NSciSu3Vju3dvurq7uubbszBXuo2Lu3cDuPQrsi5ju7pHuTmLu/zrun/kt7bLw7uzE7vZG7trB7twh7wJR7rzn7u+G7h4z7pKw7wys7vBr/uc97up9ziyY7rN+7xH3++9u4lqTyTRz3jEx/e3RvO7VHyKRnvCV/xFl/vnLzIWj6Zv7QeLl/lsy3z8A7zTeHcfBW913MBgOm4FZnJJs/xEj/sxG7BI9/KdvnJmG2YZ7XzptzVTE/xPq/OUZ8Snvy7IGb1ToH1B77n777t/R7pau3Lnkv0wWydkWH2J8/paf/kFH7wXz9tdL/1Kp/y/H33RUHkbdL3gt/xxe7wBU/U/54XWv3y4Y7xAj/wEK/teB/5kr/w+x7zXT9Qv17KZ4/2gI/yTo/4UF/zJ/e++KrP8N7O+q0v2Aj/82v/7Ku/+bI/+9X1+Sh9+KYP9K7+8JNP8/+8TPDfHvy13/Ahn/hWQfgqXvrNr/CpX/yaX+HlzvXKn/y+r/YXr+/Un6Ep+v0aWv3gP/7kP23eX/7o75/in/7s3/6o7/7wH/+NDxNEo9j1n9fAGxj2D0KKTRYAQWKChBIaHJRAuAEAARAIEQokaLAExIIHHV7EmFHjRo4XKUoUgeBDiRADRj4cWHFiSokdXb58+fFgiAINW6KMeFAmTJ49PbK0iFADAIIOd+70mTQmUIQXimI8ylTpVI5InZbYwGCEUaZIqX7lmhNj1q04VXqFCQAAWJ8hGmwN+cEtXJEO55aIezcuW7B66yKk2dDuW7wi/Z7kS/Xwxb2ACed9/Df/sdLFDm+SjCw38+Spi0lQ8JByMF3NpDlTzizigFqiFw9XPt02s1sLAAIgxkwadmyYsC/nLlw6eE+1vDe+3uxYd3LjL2EHdj2beXOXlVVDwIjcNPXq0xsDh7ydO0ftFEcH3z0+Y/qrytFPV79eunjtw+NrrEw2+3z7adfGFwg7iQJUiSsBdZrgwPs2IvAy6Aw8K8ECF8yowZkEeOonBS2ksEIJJdLvOw457FDDCVfKcMQPgypxJQX1I6ECwVyMUMEWIWzpqrtQ2nDFG3ks8DPcgBzQR+L++zFJJZdkskknn4QySimn7Kg4Kq/EMkstt+SySy+/RMhKMMcks0wzz0QzLM0nxVSzTTffhDNOOclkc04778QzTz33nKpOPv8ENFBBB+3ST0IPRTRRRRflJ8xQRh+FNFJJD3V0UksvxTTTMivVtFNPPwX1Rk5DJbVUU09VCoCAAAA7" ALT="MyPic">

 

[szimmer661]

Thank you both for the solutions and the prompt replies. I'm sure I'll be able to get one of them to work with my data.

Regards, Steve