A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

I'm not even sure how to explain this problem



 
 
Thread Tools Display Modes
  #1  
Old October 2nd, 2008, 10:01 PM posted to microsoft.public.excel.charting
Earl[_3_]
external usenet poster
 
Posts: 1
Default I'm not even sure how to explain 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.
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:17 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.