+ Reply to Thread
Results 1 to 2 of 2

Constructing a chart: HELP

  1. #1
    Registered User
    Join Date
    01-26-2006
    Posts
    3

    Constructing a chart: HELP

    Hello,

    I am looking for a graph so I can visualize customers with their margins and volumes.
    I was thinking about a rectangle for each customer:
    the lenght is "margin" on the Y-axis and the width of the rectangle is the "volume" on the X-axis.

    Can somebody help me making this graph?

    My data looks something like this (| | = 1 cell in excel):

    row A contains the customernames
    row B contains the margins
    row C contains the volumes

    |______|customer1|customer2|customer3|
    |MARGIN|marginc1 |marginc2 |marginc3 |
    |VOLUME|volumec1 |volumec2 |volumec3 |

    thanx,

    Eld0

  2. #2
    Jon Peltier
    Guest

    Re: Constructing a chart: HELP

    Try this chart:

    http://pubs.logicalexpressions.com/P...cle.asp?ID=508

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

    "Johny" <[email protected]> wrote in
    message news:[email protected]...
    >
    > Hello,
    >
    > I am looking for a graph so I can visualize customers with their
    > margins and volumes.
    > I was thinking about a rectangle for each customer:
    > the lenght is "margin" on the Y-axis and the width of the rectangle is
    > the "volume" on the X-axis.
    >
    > Can somebody help me making this graph?
    >
    > My data looks something like this (| | = 1 cell in excel):
    >
    > row A contains the customernames
    > row B contains the margins
    > row C contains the volumes
    >
    > |______|customer1|customer2|customer3|
    > |MARGIN|marginc1 |marginc2 |marginc3 |
    > |VOLUME|volumec1 |volumec2 |volumec3 |
    >
    > thanx,
    >
    > Eld0
    >
    >
    > --
    > Johny
    > ------------------------------------------------------------------------
    > Johny's Profile:
    > http://www.excelforum.com/member.php...o&userid=30859
    > View this thread: http://www.excelforum.com/showthread...hreadid=538790
    >




+ 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