Solved

Excel 2003 graph looks different in Excel 2007

Posted on 2011-03-10
5
557 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 250 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 250 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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

630 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