| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Showing one figure as a proportion of another in a bar graph
Hi,
I have a table with three lines for every month of the year: one line showing the total we billed in the month, the other showing our total expenditure and a final showing profit. I want to use the table to create a bar graph that for each month shows the total billed and the the total paid out in the same bar. Can anyone tell me how to do that? Thanks Karl |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Showing one figure as a proportion of another in a bar graph
Hi Karl,
Sounds like what you want is a Stacked Column chart. -- Cheers, Shane Devenshire "Karl" wrote: Hi, I have a table with three lines for every month of the year: one line showing the total we billed in the month, the other showing our total expenditure and a final showing profit. I want to use the table to create a bar graph that for each month shows the total billed and the the total paid out in the same bar. Can anyone tell me how to do that? Thanks Karl |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Picture Proportion During Printing | Excel Discussion (Misc queries) | |||
| I am trying to figure out how to plot a graph like given -(x 3)^2 | Excel Discussion (Misc queries) | |||
| Showing numerator in graph | Excel Discussion (Misc queries) | |||
| Raise numbers in the same proportion.. | Excel Discussion (Misc queries) | |||
| to stop zero from showing on graph | Charts and Charting in Excel | |||
Linear Mode
