| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
percentage/figs on the same graph
I am trying to produce a chart showing monthly number of referrals for 4
people and with another column showing percentages. The chart i have chosen is column with a line to show the percentage fig. The first column (A) has there names. Column B has there monthly totals and column C has the percentage figs. All 3 colums represent 1 month and i done the same for a whole year. The issue i am not able to show the percentage fig in the line graph. Is there any way i can achieve the above without having to produce a seperate graph. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...chart/200710/1 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
percentage/figs on the same graph
Go ahead and add a series for the Percentage
Double click on the data series to format the data series and select the axis tab. Select secondary axis. -- HTH, Barb Reinhardt "chedd via OfficeKB.com" wrote: I am trying to produce a chart showing monthly number of referrals for 4 people and with another column showing percentages. The chart i have chosen is column with a line to show the percentage fig. The first column (A) has there names. Column B has there monthly totals and column C has the percentage figs. All 3 colums represent 1 month and i done the same for a whole year. The issue i am not able to show the percentage fig in the line graph. Is there any way i can achieve the above without having to produce a seperate graph. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...chart/200710/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| show value as percentage in stacked bar graph | Charts and Charting in Excel | |||
| Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
| Creating a stacked column chart with percentage in the graph | Charts and Charting in Excel | |||
| I need to math manipulate figs over 10,000( in hrs & min format)? | Excel Discussion (Misc queries) | |||
| Hyperlinkage of one graph with another graph or Drill down graph | Charts and Charting in Excel | |||
Linear Mode
