Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Excel 2003 graph looks different in Excel 2007

Posted on 2011-03-10
5
Medium Priority
?
565 Views
Last Modified: 2012-06-27
I have an Excel doc that I had created a graph in Excel 2003.  We just recently upgraded to Office 2007 and now I am having issues with the colors.  When I open the doc in Excel 2007, the graph has colored lines through the graph which are vertical.  I have attached screenshots of each so you can see it.  Please help!

Thank you in advance for your help.
Excel-2003.bmp
Excel-2007.png
0
Comment
Question by:SuperRhino
5 Comments
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 35098634
SuperRhino: Is it possible for me to see the actual file?

Sid
0
 
LVL 2

Author Comment

by:SuperRhino
ID: 35099447
I attached the doc to response.

Thanks
Web-Sales-2011.xls
0
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 35114058
Hmmm. This has me baffled. Let me see if I can get more experts to join in :)

Sid
0
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 1000 total points
ID: 35114218
It's a rendering issue. Zoom in or out and see that the pattern changes.

Is there any reason why you are including a gazillion columns with  the same value? Does not really help the overall chart, does it. Why not change it to a line? Or make the whole thing an area chart, since the columns blend into each other anyway. With so many columns, it also is not a good idea to use a separate border color for each column.

cheers, teylyn
0
 
LVL 42

Assisted Solution

by:dlmille
dlmille earned 1000 total points
ID: 35141927
Part of it is the rendering, but its because the border style of the "flutes" are not translating from 2003 to 2007.  Play around with border style and weight of the "flute" and you'll get back to where you were.

See pic and attached.

Revised in Excel 2007
Neat chart, by the way.

Dave  
Web-Sales-2011-r2.xls
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question