Charts

SeanRafferty

New Member
Joined
Sep 17, 2002
Messages
4
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

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
Hi - welcome to the board!

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

Paddy
 

SeanRafferty

New Member
Joined
Sep 17, 2002
Messages
4
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.
 

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
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'.

paddy
 

SeanRafferty

New Member
Joined
Sep 17, 2002
Messages
4
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
 

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
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.

Paddy
 

Forum statistics

Threads
1,144,743
Messages
5,726,025
Members
422,654
Latest member
Yashpalknl

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