Creating a Chart

Charlie_Chalk

Board Regular
Joined
Sep 15, 2002
Messages
93
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
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

cherria

Well-known Member
Joined
Nov 17, 2004
Messages
708
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

Board Regular
Joined
Sep 15, 2002
Messages
93
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

Well-known Member
Joined
Nov 17, 2004
Messages
708
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 :)
 

Forum statistics

Threads
1,147,621
Messages
5,742,188
Members
423,710
Latest member
Duarte85

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top