Home |
Search |
Today's Posts |
#1
|
|||
|
|||
percentage not active?!
i have two data series that i want to represent as a stacked 3d column, i
want the percentage of each out of the total column height to be shown but the data series option for percentage check mark is not active??!! why is this and how can i add the percntage to the value?..please help |
#2
|
|||
|
|||
Assuming the setup below where the columns labeled "a" and "b" are your
original data, add two additional columns to compute your percentages. Your spreadsheet should look like this: a b c d a 4 6 40% 60% b 2 4 33% 67% c 3 5 38% 63% d 4 3 57% 43% e 6 2 75% 25% f 5 5 50% 50% Build you chart based on the first three columns. Do not refer to the columns labeled "c" or "d" when you build the chart. These columns will be used for data labeling purposes only. Once your chart is built, you will need a tool such as Rob Bovey's XY Chart Labeler http://www.appspro.com/Utilities/ChartLabeler.htm or John Walkenbach's Chart Tools http://j-walk.com/ss/excel/files/charttools.htm to add the % labels to your chart. Alternatively, you can use the following macro: Sub AddLabels() Dim RngLabels As Range Dim Ser As Series Dim i As Long If TypeName(Selection) = "Series" Then Set Ser = Selection Set RngLabels = Application.InputBox(prompt:="Select the label range:", Type:=8) Ser.HasDataLabels = True For i = 1 To Ser.Points.Count Ser.Points(i).DataLabel.Text = RngLabels(i) Next i Else MsgBox "Select a series in a chart." End If End Sub Add the macro to a standard module. Click on one of the chart series once. Then, run the macro. The macro will prompt you for a data range. Enter the range of percentages that you want to go with the series that you have selected. When complete all you need to do is format the data that has been added to the chart as a percentage. ---- Regards, John Mansfield http://www.pdbook.com "kafoury123" wrote: i have two data series that i want to represent as a stacked 3d column, i want the percentage of each out of the total column height to be shown but the data series option for percentage check mark is not active??!! why is this and how can i add the percntage to the value?..please help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Woorksheet locked on active cell | Excel Worksheet Functions | |||
How do I have an active cell highlight automatically | Excel Discussion (Misc queries) | |||
percentage of sales | Excel Worksheet Functions | |||
HOW TO COPY 480 ACTIVE E-MAIL ADDRESSES CLM "G" ON AN ACTIVE EXCE. | Excel Discussion (Misc queries) | |||
Unable to set the active cell from VBA | New Users to Excel |