# Charts

#### SeanRafferty

##### New Member
OK im a little new to all this but find it great fun my problem is , I would like to do a bar chart but instead of using numerical data for bars I would like to use letters can this be done and if it can HOW any help woud be much appreciated, Thank's.
Sean

### Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
Hi - welcome to the board!

How would you scale your y axis? Post back with more info on your problem...

Thanks Paddy, I have been using the numbers 0 and 1 in cell's to show buildings that I have checked and passed 0 being not passed and 1 being passed I woul like to use a third variable for not checked. but also instead of numbers would like to use letters:
eg: P for passed, N/P for not passed and N/C for not checked the problem is I can't get a graph up and displayed using letter's is there a way around this. Thanks for the quick reply Sean.

On 2002-09-19 10:59, SeanRafferty wrote:
Thanks Paddy, I have been using the numbers 0 and 1 in cell's to show buildings that I have checked and passed 0 being not passed and 1 being passed I woul like to use a third variable for not checked. but also instead of numbers would like to use letters:
eg: P for passed, N/P for not passed and N/C for not checked the problem is I can't get a graph up and displayed using letter's is there a way around this. Thanks for the quick reply Sean.

So what would your chart look like? Counts of N/C's?? Post back with what you mean by 'graphed up'.

Thanks Paddy, all I mean by Graph Up is that I cant get the graph displayed because I think the cells will only display data in numerical form as oppose to letters (A, N/A, N/C.) Would I be right in thinking that.
Thanks Sean

Basically, yes - numbers only in the data area of the graph, but again - what are you actually tryiung to do here - detail the outcone you're looking for & there's usually a work around to get an acceptable result.

Replies
0
Views
166
Replies
3
Views
453
Replies
6
Views
233
Replies
1
Views
451
Replies
1
Views
97

1,219,036
Messages
6,145,918
Members
450,655
Latest member
Calvest1

### 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?

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