Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pie Chart
I would like to make my pie chart show both labels and values is this
possible? I know i can do labels and percentages but this is no good. The only way i can think of is showing the values and a legend but this wont be great as there maybe many sections of the pie chart. Any ideas? Thanks. -- Cheers, Ben Remove your.tonsils to reply "You only live once but if you do it right once is enough!" |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pie Chart
You can use a formula to create the label that you want. For example,
with categories in cells A1:A10 and values in B1:B10 -- 1. Enter the following formula in cell C1: =A1 & CHAR(10) & B1 2. Copy this formula down to C10 (ignore the white box that appears in the formula) 3. Select cells B1:B10, and click the Chart Wizard button 4. Select the Pie chart, and one of the pie chart subtypes 5. In step 2 of the Wizard, on the Series tab, click in the Category Labels box, then select cells C1:C10 6. In step 3, on the Labels tab, select 'Show label' 7. Click Finish Ben Allen wrote: I would like to make my pie chart show both labels and values is this possible? I know i can do labels and percentages but this is no good. The only way i can think of is showing the values and a legend but this wont be great as there maybe many sections of the pie chart. Any ideas? Thanks. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pie Chart
Debra Dalgleish wrote:
You can use a formula to create the label that you want. For example, with categories in cells A1:A10 and values in B1:B10 -- 1. Enter the following formula in cell C1: =A1 & CHAR(10) & B1 2. Copy this formula down to C10 (ignore the white box that appears in the formula) 3. Select cells B1:B10, and click the Chart Wizard button 4. Select the Pie chart, and one of the pie chart subtypes 5. In step 2 of the Wizard, on the Series tab, click in the Category Labels box, then select cells C1:C10 6. In step 3, on the Labels tab, select 'Show label' 7. Click Finish Ben Allen wrote: I would like to make my pie chart show both labels and values is this possible? I know i can do labels and percentages but this is no good. The only way i can think of is showing the values and a legend but this wont be great as there maybe many sections of the pie chart. Any ideas? Thanks. Thats exactly what i was after, thanks Debra -- Cheers, Ben Remove your.tonsils to reply "You only live once but if you do it right once is enough!" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Chart - determining the color of a chart style | Charts and Charting in Excel | |||
Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard | Charts and Charting in Excel | |||
Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard | Setting up and Configuration of Excel | |||
Creating a chart(? pie chart) that shows customers,dates and machi | Charts and Charting in Excel | |||
vc++ automation: opening chart as chart window and setting scale | Excel Programming |