Excel 2003 graph looks different in Excel 2007

Posted on 2011-03-10
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.
Question by:SuperRhino
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
LVL 30

Expert Comment

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


Author Comment

ID: 35099447
I attached the doc to response.

LVL 30

Expert Comment

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

LVL 50

Accepted Solution

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
LVL 42

Assisted Solution

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.


Featured Post

Increase your protection from Zero Day threats!

Running two Antivirus' is never a good idea.
Taking advantage of Multiple Security layers on the other hand can often save your hide.
See which top notch security software brands have been proven to happily coexist together.
Reduce your chances of becoming a statistic.

Question has a verified solution.

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

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

751 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