Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to produce a chart based on number of cells not values in thecells
Hi
I'm using Excel 2007. I have a requirement to base a chart on the number cells rather than the values in the cell. For example, here are some values I might enter against Monday to Friday: 1,3,1,1,2 In this example, I want my (pie) chart to show that 3/5 are value 1, 1/5 is value 2 and 1/5 is value 3 (i.e. the pie chart should have 3 sections). What excel does, is split the chart into 8 sections, and shows each individual value. Any suggestions on how I might achieve this, Thanks for any help Colin |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to produce a chart based on number of cells not values in the cells
You need to do some calculations in the sheet first, then plot the results:
http://peltiertech.com/Excel/ChartsH...idateData.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Bobby" wrote in message ... Hi I'm using Excel 2007. I have a requirement to base a chart on the number cells rather than the values in the cell. For example, here are some values I might enter against Monday to Friday: 1,3,1,1,2 In this example, I want my (pie) chart to show that 3/5 are value 1, 1/5 is value 2 and 1/5 is value 3 (i.e. the pie chart should have 3 sections). What excel does, is split the chart into 8 sections, and shows each individual value. Any suggestions on how I might achieve this, Thanks for any help Colin |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to produce a chart based on number of cells not values in thecells
Thanks
Trying it now, Colin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function to Produce a Number Pattern? | Excel Worksheet Functions | |||
max number based on multiple values | Excel Discussion (Misc queries) | |||
How do I produce a number in parentheses? | Excel Discussion (Misc queries) | |||
help me on rearrange cells based on its numerical values without repeating any number | Excel Worksheet Functions | |||
produce a formulate to produce assigned seats for dinner | Excel Worksheet Functions |