Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    195
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Bar chart with 2 axis

    I would like to use a bar chart graph to represent a monthly variance (2 bars) and a yearly variance (2 bars). How can I have 2 axis? one for the 2 monthly bars and one for the 2 yearly bar.

  2. #2
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Richmond, Virginia, USA
    Posts
    416
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Bar chart with 2 axis

    I'm not sure if this is what you're asking for, but you can set up a 3D chart that has an X, Y, and a Z axis. To create this type of bar graph, go to Insert-Chart and select a bar graph on the left and a 3D bar graph on the left. On the 3rd step of the Chart wizard, you can put in your info for the X, Y, and Z axes.

    Let us know if this is what you needed. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Becky

  3. #3
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Bar chart with 2 axis

    Is there something in <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=xl&Number=31553&page=&view= &sb=&vc=1>this thread</A> which may be of use?
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  4. #4
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    195
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Bar chart with 2 axis

    Thanks for your proposal but it is not exactly what I am looking for. Geoff gives me a good thread and I am trying to get the result.

    Thanks for your help.

Posting Permissions

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