+ Reply to Thread
Results 1 to 4 of 4

[SOLVED] Can you have a vertical line graph in Excel 2003

  1. #1
    smithers2002
    Guest

    [SOLVED] Can you have a vertical line graph in Excel 2003

    Is it possible to make a combination graph with a vertical line graph
    included? It would appear you can only have line graphs which are plotted on
    the y graph at the moment

  2. #2
    Jon Peltier
    Guest

    Re: Can you have a vertical line graph in Excel 2003

    You can use an XY Scatter chart instead, perhaps using a dummy series to provide
    non-numeric vertical axis labels:

    http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html

    - Jon
    -------
    Jon Peltier, Microsoft Excel MVP
    Peltier Technical Services
    Tutorials and Custom Solutions
    http://PeltierTech.com/
    _______

    smithers2002 wrote:

    > Is it possible to make a combination graph with a vertical line graph
    > included? It would appear you can only have line graphs which are plotted on
    > the y graph at the moment



  3. #3
    smithers2002
    Guest

    Re: Can you have a vertical line graph in Excel 2003

    Hi, Thanks, I looked at your site but the graph does not work. I am using a
    100% stacked bar chart/stacked bar chart and need a vertical series showing
    another value- when I try to do this, it keeps returning the values on a
    horizontal axis. Please help, its really annoying me!


    "Jon Peltier" wrote:

    > You can use an XY Scatter chart instead, perhaps using a dummy series to provide
    > non-numeric vertical axis labels:
    >
    > http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html
    >
    > - Jon
    > -------
    > Jon Peltier, Microsoft Excel MVP
    > Peltier Technical Services
    > Tutorials and Custom Solutions
    > http://PeltierTech.com/
    > _______
    >
    > smithers2002 wrote:
    >
    > > Is it possible to make a combination graph with a vertical line graph
    > > included? It would appear you can only have line graphs which are plotted on
    > > the y graph at the moment

    >
    >


  4. #4
    Jon Peltier
    Guest

    Re: Can you have a vertical line graph in Excel 2003

    The XY Scatter chart series overlaid on the Bar chart has vertical Y and horizontal
    X, while the bar chart series have vertical X and horizontal Y. For the XY Scatter
    series, use a Y coordinate that goes from 1 to N, 1 corresponding to the lowest
    horizontal bar category, and N to the number of categories. Use an X value
    corresponding to the Y values of the bars.

    This is the relevant page:

    http://peltiertech.com/Excel/Charts/BarLineCombo.html

    - Jon
    -------
    Jon Peltier, Microsoft Excel MVP
    Peltier Technical Services
    Tutorials and Custom Solutions
    http://PeltierTech.com/
    _______

    smithers2002 wrote:

    > Hi, Thanks, I looked at your site but the graph does not work. I am using a
    > 100% stacked bar chart/stacked bar chart and need a vertical series showing
    > another value- when I try to do this, it keeps returning the values on a
    > horizontal axis. Please help, its really annoying me!
    >
    >
    > "Jon Peltier" wrote:
    >
    >
    >>You can use an XY Scatter chart instead, perhaps using a dummy series to provide
    >>non-numeric vertical axis labels:
    >>
    >> http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html
    >>
    >>- Jon
    >>-------
    >>Jon Peltier, Microsoft Excel MVP
    >>Peltier Technical Services
    >>Tutorials and Custom Solutions
    >>http://PeltierTech.com/
    >>_______
    >>
    >>smithers2002 wrote:
    >>
    >>
    >>>Is it possible to make a combination graph with a vertical line graph
    >>>included? It would appear you can only have line graphs which are plotted on
    >>>the y graph at the moment

    >>
    >>



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1