Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
vertical graphs
how do you make the x axis the dependent variable and the Y axis the
independent variable so that the curves progress up instead of across? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
vertical graphs
You're going to need to give us some more info. What kind of chart are you
talking about? For instance, bars can go horizontal (Bar Chart) instead of vertical (Column Chart.) This doesn't sound too difficult, but we can't help much without some more specifics. Why not give us a couple of short columns of numbers and a better description of what you need the chart to look like. "jimF" wrote in message ... how do you make the x axis the dependent variable and the Y axis the independent variable so that the curves progress up instead of across? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
vertical graphs
Hi,
Try using the xy scatter rather than the Line chart. That way you can specify the ranges for both x and y values. You will probably need to generate a set of default values for the y axis. Cheers Andy jimF wrote: how do you make the x axis the dependent variable and the Y axis the independent variable so that the curves progress up instead of across? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
vertical graphs
This example helps illustrate what Andy is describing:
http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Andy Pope" wrote in message ... Hi, Try using the xy scatter rather than the Line chart. That way you can specify the ranges for both x and y values. You will probably need to generate a set of default values for the y axis. Cheers Andy jimF wrote: how do you make the x axis the dependent variable and the Y axis the independent variable so that the curves progress up instead of across? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
vertical graphs
I just figured it out. I assumed the x values had to be the same for all
curves. By making the yvalues the same(independent) and vary the x values(dependent) you get the curves to progress up instead of across. "Jon Peltier" wrote: This example helps illustrate what Andy is describing: http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Andy Pope" wrote in message ... Hi, Try using the xy scatter rather than the Line chart. That way you can specify the ranges for both x and y values. You will probably need to generate a set of default values for the y axis. Cheers Andy jimF wrote: how do you make the x axis the dependent variable and the Y axis the independent variable so that the curves progress up instead of across? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
vertical graphs
Like this example:
http://peltiertech.com/Excel/ChartsH...html#manyxoney - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "jimF" wrote in message ... I just figured it out. I assumed the x values had to be the same for all curves. By making the yvalues the same(independent) and vary the x values(dependent) you get the curves to progress up instead of across. "Jon Peltier" wrote: This example helps illustrate what Andy is describing: http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Andy Pope" wrote in message ... Hi, Try using the xy scatter rather than the Line chart. That way you can specify the ranges for both x and y values. You will probably need to generate a set of default values for the y axis. Cheers Andy jimF wrote: how do you make the x axis the dependent variable and the Y axis the independent variable so that the curves progress up instead of across? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making graphs from updates... | Excel Worksheet Functions | |||
Excel plugin to make graphs look better | Excel Discussion (Misc queries) | |||
How to add a vertical bar to a column chart to display AVERAGE val | Charts and Charting in Excel | |||
Help! My graphs sneezed! | Charts and Charting in Excel | |||
How do I limit the vertical scroll? | Setting up and Configuration of Excel |