+ Reply to Thread
Results 1 to 2 of 2

Two axis- is it possible to have one bar and one point?

  1. #1
    Registered User
    Join Date
    10-08-2004
    Posts
    1

    Two axis- is it possible to have one bar and one point?

    hi, i have created a BAR chart(horizontal) and have two series of data with two axis at top and bottom. I would like one of the data series not to be represented with a bar but with a point, like on a scatter graph. Is this possible, and if so, please could you let me know asap how to do this. Important bit of work being carried out. Thank you so much for your time.
    Last edited by londonal; 05-18-2006 at 09:57 AM.

  2. #2
    Jon Peltier
    Guest

    Re: Two axis- is it possible to have one bar and one point?

    A "line" chart cannot be oriented with its category vertical, that is,
    parallel to the bar chart's. However, you can use an XY series type, with
    the source data for the X and Y as appropriate to a horizontal X axis, and
    using various scaling factors to assure correspondence of the two series.

    This example may help:

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

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


    "londonal" <londonal.280a5c_1147960202.3824@excelforum-nospam.com> wrote in
    message news:londonal.280a5c_1147960202.3824@excelforum-nospam.com...
    >
    > hi, i have created a BAR chart(horizontal) and have two series of data
    > with two axis at top and bottom. I would like on of the data series not
    > to be represented with a bar but with a point, like on a scatter graph.
    > Is this possible, and if so, please could you let me know asap how to do
    > this. Important bit of work being carried out. Thank you so much for
    > your time.
    >
    >
    > --
    > londonal
    > ------------------------------------------------------------------------
    > londonal's Profile:
    > http://www.excelforum.com/member.php...o&userid=15133
    > View this thread: http://www.excelforum.com/showthread...hreadid=543289
    >




+ 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