Creating a Chart

[Charlie_Chalk]

Hi

I have the following data that I would like to create a chart from

A B
1 1 0
2 2 0
3 3 1
4 4 2
5 5 4
6 6 2
7 7 0
8 8 1
9 9 5
10 10+ 0

Column A is number of days, Column B number of jobs produced in x days - so, 1 job took 3 days to produce, 2 jobs took 4 days, 4 jobs took 5 days etc.

The only way I can make a chart out of this is by having the number of days along the horizontal axis, and number of jobs along the vertical. This makes it very hard to read.

When I try to get the number of jobs along the horizontal the chart includes the 0 jobs on 1, 2, 7 and 10+ days and gives me a straight line from bottom left corner to top right.

Can anyone tell me if it is possible, or do I need to change the spreadsheet round to get the chart I need?

CC

 

[cherria]

Sorry if you have tried this, but can't you just change the chart type from column to bar. This way you get horizontal bars rather than vertical bars?

 

[Charlie_Chalk]

hmmm, yes that would do it!! I think I was looking to hard for a complicated solution and missed the obvious.

If there are any jobs that take over 7 days to produce they apear in red in the workbook (conditional formatting). Is there any way to change the colour of a bar depended on its value?

Thanks again for your help!

CC

 

[cherria]

I'm not aware of any way of conditionally formatting the bars on a bar chart. I'm sure it could be done with a macro if somebody out there cares to take a stab at it