Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
2 Vertical Axis? Not sure what I am looking for...
I am trying to make a chart that can be used to illustrate a count from
multiple problems to multiple sources. I want the bottom axis (horizontal) to be a list of devices that could have a problem. Then I want the left (Vertical) axis to show possible problems with the device. I then want to show another axis (on the right vertical) that is a number count. Then I want the data point to be in the chart. For instance if there is a problem a dot will be on the chart inline with a number, and if you look down it will tell you which device that applies to. I wish I could draw you a picture. If 5 of one device faced a specific problem, a dot would be above that device in the chart field, inline with the problem and number 5. I need a solution by tonight...I am using Excel 2007, but need an answer that applies to 2003 as well. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
2 Vertical Axis? Not sure what I am looking for...
Never mind, it was a long day and looking back now I realize that made no
sense. "1genxer" wrote: I am trying to make a chart that can be used to illustrate a count from multiple problems to multiple sources. I want the bottom axis (horizontal) to be a list of devices that could have a problem. Then I want the left (Vertical) axis to show possible problems with the device. I then want to show another axis (on the right vertical) that is a number count. Then I want the data point to be in the chart. For instance if there is a problem a dot will be on the chart inline with a number, and if you look down it will tell you which device that applies to. I wish I could draw you a picture. If 5 of one device faced a specific problem, a dot would be above that device in the chart field, inline with the problem and number 5. I need a solution by tonight...I am using Excel 2007, but need an answer that applies to 2003 as well. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
make chart with both horizontal-x axis vertical-y axis | Charts and Charting in Excel | |||
Only 2 vertical axis? | Charts and Charting in Excel | |||
Dual Vertical Y-Axis | Charts and Charting in Excel | |||
Dual Vertical Y-Axis | Charts and Charting in Excel | |||
can I make the vertical axis the category axis in Excel line graph | Charts and Charting in Excel |