+ Reply to Thread
Results 1 to 3 of 3

I'm not even sure how to describe this problem

  1. #1
    Registered User
    Join Date
    10-02-2008
    Location
    Chicago
    Posts
    1

    I'm not even sure how to describe this problem

    I have a graph that displays 4 different pieces of information in a bar
    chart, A-1 and A-2 both in the same year, then B-1 and B-2 information is
    displayed on top of the corresponding A-1 and A-2.

    See this link
    http://copleyadvisors.com/pages/Extr...1stQtr2008.pdf
    Page 2, Graph in top left entitled "1st Qtr CBD Vacancy".

    What I'm doing now is graphing all 4 bars side by side and then moving them
    so they overlap, what happens is you end up with a gap between bars in the
    same year.

    I've tried all different ways to do this and have not figured it out. I've
    tried using two seperate graphs and having the top with a transparent
    background overlay the bottom but it's impossible to get the bars to lineup
    perfectly.

    Thanks ahaed of time for any help.

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    I'm not even sure how to describe this problem
    Welcome to the forum. You are going to have to try to describe the problem as per our forum rules below

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,430
    Does this help?
    http://peltiertech.com/WordPress/200...column-charts/
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel date problem
    By hermiod in forum Excel General
    Replies: 4
    Last Post: 07-16-2007, 10:22 AM
  2. Cut and Paste Problem
    By agila916 in forum Excel General
    Replies: 4
    Last Post: 07-09-2007, 05:36 PM
  3. Excel 2007/ Outlook 2007 mail Problem
    By Bostock in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-25-2007, 04:26 PM
  4. Countif funtions problem
    By mike4545 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-17-2007, 02:37 PM
  5. Cell function problem
    By itty in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-19-2007, 08:27 AM

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