Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Creating charts from formula results
Im trying to create a chart in Excel based on the reult of a column or formula's I wrote. The chart just seems to show the formula as its values, can anyone help? I had a list of employee ages and used a formula to indicate their age bracket (e.g. 16-24, 25-30, 31-40 etc). I now want a bar chart that will show how many employee's are in each bracket. Help is much appreciated asap as its for my job. Thanks in advance. -- Boba Fett ------------------------------------------------------------------------ Boba Fett's Profile: http://www.excelforum.com/member.php...o&userid=26509 View this thread: http://www.excelforum.com/showthread...hreadid=397767 |
#2
|
|||
|
|||
Sometimes it is neater to reproduce the information for a chart in an area
of the sheet that does not print. You need several headings (16-24, etc.) which could go on one line, and the corresponding values on the next line. Then select all the active cells in these two lines and construct the chart from there. If the values might chance, make the value cells cross-reference the cells where the actual formula results reside (e.g. cell F2=B7). "Boba Fett" wrote in message ... Im trying to create a chart in Excel based on the reult of a column or formula's I wrote. The chart just seems to show the formula as its values, can anyone help? I had a list of employee ages and used a formula to indicate their age bracket (e.g. 16-24, 25-30, 31-40 etc). I now want a bar chart that will show how many employee's are in each bracket. Help is much appreciated asap as its for my job. Thanks in advance. -- Boba Fett ------------------------------------------------------------------------ Boba Fett's Profile: http://www.excelforum.com/member.php...o&userid=26509 View this thread: http://www.excelforum.com/showthread...hreadid=397767 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating an EXCEL COUNTIF formula for a range of values | Excel Discussion (Misc queries) | |||
Excell only displays the formula, not the results | Excel Discussion (Misc queries) | |||
Bold part of formula results | Excel Discussion (Misc queries) | |||
can i colour a cell on basis of results of a formula e.g clour bl. | Excel Worksheet Functions |