| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Data Sets
Not sure if this makes sense but is it possible to show various data sets on one graph? For example, I presently have a chart that shows P vs. A, this is projected vs. actual. I want to include efficiency on the same chart but it is in %, whereas the P vs. A is in regular numbers. So when I try to do it, efficiency shows at the bottom or zero. It is actually 120%+ but does not show. Is it possible to show % and regular numbers on the same chart? Thanks. -- corona91719 ------------------------------------------------------------------------ corona91719's Profile: http://www.excelforum.com/member.php...o&userid=32527 View this thread: http://www.excelforum.com/showthread...hreadid=523093 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple Data Sets
"corona91719"
wrote in message ... Not sure if this makes sense but is it possible to show various data sets on one graph? For example, I presently have a chart that shows P vs. A, this is projected vs. actual. I want to include efficiency on the same chart but it is in %, whereas the P vs. A is in regular numbers. So when I try to do it, efficiency shows at the bottom or zero. It is actually 120%+ but does not show. Is it possible to show % and regular numbers on the same chart? Select the second series, Format axis, and select "secondary axis". -- David Biddulph |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to show multiple data sets on one bar chart | Charts and Charting in Excel | |||
| how do i import multiple data sets at one time? | Excel Discussion (Misc queries) | |||
| Two data sets, one average | Charts and Charting in Excel | |||
| Reference multiple cells in if statement | Excel Worksheet Functions | |||
| How do I pull in multiple data sets at once? | Excel Discussion (Misc queries) | |||
Linear Mode
