Re: Complex Graph

It's a relatively simple stacked bar chart. There are two bars for each
area, either the red or green one has value of 1, the other zero, depending
on whether the county met the goal in that area.

I've posted a zipped workbook with my data (note the formulas) and
semi-documented views of the chart each step of the way:

http://peltiertech.com/Sample/NewsGroup_RedGreenBlocks.zip

It's not really pretty, but with formatting, perhaps it could be made
useful.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"davegb" <davegbel@xxxxxxxxxxx> wrote in message
news:175d1116-01d9-4d9f-accc-fe46dc30eeff@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I've been asked if I can create a horizontal bar graph in which 10
counties each have 9 areas in which they will be compared with a score
between 0 and 100%. In each of the 9 categories, there is a target
percentage. The Director wants to see a horizontal bar chart with the
results for each county in each of the 9 categories, but counties
color-coded by whether or not they met the target percentage. So if
county x scored 85% and the target was 87%, the bar would be red. If
they scored better than 87%, it would be green.

I don't think this is doable in XL. Does anyone know how to do
something like this?

Thanks.

Dave


.

Relevant Pages

  • Re: Calculation of snr
    ... a normal bar chart target is a 50-50 square wave. ... Indeed, yes, but you can predict the SNR on the retina of a square-wave ...
    (rec.photo.digital)
  • Re: Calculation of snr
    ... and working out the SNR on the retina. ... While a bar chart target is not a sine wave, ...
    (rec.photo.digital)
  • Re: Target line
    ... Jon Peltier has instructions for adding a line to a chart: ... Pat Jennings wrote: ... > How is a target line, say 98%, included in a bar chart? ... > data is less than the target, ...
    (microsoft.public.excel.charting)
  • Re: Complex Graph
    ... counties each have 9 areas in which they will be compared with a score ... The Director wants to see a horizontal bar chart with the ... color-coded by whether or not they met the target percentage. ... county x scored 85% and the target was 87%, ...
    (microsoft.public.excel.programming)
  • Re: Complex Graph
    ... on whether the county met the goal in that area. ... counties each have 9 areas in which they will be compared with a score ... The Director wants to see a horizontal bar chart with the ... color-coded by whether or not they met the target percentage. ...
    (microsoft.public.excel.programming)
Loading