| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 60524 | 2005-08-04 09:55:00 | Microsoft Excel Help | Ninjabear (2948) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 378248 | 2005-08-04 09:55:00 | HI I manage to plot the data onto a piegraph with microsoft excel but how do I take a slice out of the pie graph? |
Ninjabear (2948) | ||
| 378249 | 2005-08-04 10:05:00 | Click in the pie chart then click the section twice - there should be six handles (little squares) around just that section. Now that the section is selected you can drag it with your mouse. hth |
Parry (5696) | ||
| 378250 | 2005-08-04 11:06:00 | Thanks for that it worked I have made a pie graph as stated.How do i get excel to display the % proportion of each slice? |
Ninjabear (2948) | ||
| 378251 | 2005-08-04 11:35:00 | Select Chart|Chart Options|Data Labels tab from the menu then select the percentage checkbox. regards, Graham |
Parry (5696) | ||
| 378252 | 2005-08-04 18:52:00 | Thanks for that Now for the next question. I have made a bar graph and I wish to tell excel to insert a line touching the tip of bar.How do i do this? This line will show me the ending cash figure for each month.Like a time series line graph. At the moment I have two bars sticking together One showing Room receipts for each month and the other bar showing total receipts for each over a period of 12 months with two bars sticking together in each month. if i right click and select the chart type and scroll down to line-column and it would convert total receipt into a line which goes across a period of 12 months. I don't want it to do that.I want a line place on top of the two bars that goes across with a period of 12 months which tells me how the motel is doing Understand? The question says Develop and print (in black and white, not colour) a combination chart which shows ending cash as a line graph superimposed on the previous column chart. A title, legend and axes labels are essential. |
Ninjabear (2948) | ||
| 378253 | 2005-08-05 06:47:00 | if we keep giving you the answers? Try the F1 key instead of the F1 site. | wotz (335) | ||
| 378254 | 2005-08-05 07:41:00 | that was the last question.Everything else of the table has been completed | Ninjabear (2948) | ||
| 378255 | 2005-08-08 06:46:00 | Hi, I think your talking about a combo chart, where you want both a bar and a line chart. See Jon Peltier's (www.peltiertech.com) site as he is a whiz on Excel charts and manipulating them. regards, Graham. |
Parry (5696) | ||
| 378256 | 2005-08-09 06:32:00 | Thanks Graham That site solved one of my problems that I was unable to describe sufficiently to post a question about. |
wotz (335) | ||
| 1 | |||||