| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charting different data formats in the same chart
Not sure if this is possible or not. Ive got a sheet with three columns
A=total number of items B=is the percentage of each row to the grand total of items in column A C=is a dollar amount. Im trying to create a bar graph that reflects all three columns. Can this be done or do I need to make three separate charts and if thats the case is it possible to combine bar charts? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Charting different data formats in the same chart
Milo,
Whenever I've had to do this type of graph, I would do the total as a column graph using the left axis, the dollar amount as a line using the right axis, then I'd use the x-y labeler (see link below) and place the percentage as a label above the column. Just my idea... Link to X-Y Labeler Application: http://www.appspro.com/Downloads/XYChartLabeler.exe Good luck! Rita MILO wrote: Not sure if this is possible or not. Ive got a sheet with three columns A=total number of items B=is the percentage of each row to the grand total of items in column A C=is a dollar amount. Im trying to create a bar graph that reflects all three columns. Can this be done or do I need to make three separate charts and if thats the case is it possible to combine bar charts? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Charting different data formats in the same chart
Good stuff thank you very much
"Rita Brasher" wrote: Milo, Whenever I've had to do this type of graph, I would do the total as a column graph using the left axis, the dollar amount as a line using the right axis, then I'd use the x-y labeler (see link below) and place the percentage as a label above the column. Just my idea... Link to X-Y Labeler Application: http://www.appspro.com/Downloads/XYChartLabeler.exe Good luck! Rita MILO wrote: Not sure if this is possible or not. Ive got a sheet with three columns A=total number of items B=is the percentage of each row to the grand total of items in column A C=is a dollar amount. Im trying to create a bar graph that reflects all three columns. Can this be done or do I need to make three separate charts and if thats the case is it possible to combine bar charts? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Charting Time formats | Charts and Charting in Excel | |||
| How do I keep excel chart "data table" formats in several workbook | Charts and Charting in Excel | |||
| Charting data points and show a target range on the same chart. | Charts and Charting in Excel | |||
| Chart not charting right | Charts and Charting in Excel | |||
| copying excel chart formats from one chart to another | Excel Discussion (Misc queries) | |||
Linear Mode
