Avatar of gh_user
gh_user
Flag for Australia asked on

excel graph issue

Im using a program that exports data into an EXcel file to produce a graph.  (see attached file)
But the graph I get has '[Cell Range]' shown instead of the point number (eg A).
A colleague when he uses it gets the point numbers correctly shown.
But another colleague gets the same problem as me.
Spoke to the program developer and he advised there was not aware of anything he could do from the software side and it appeared to be something to do with excel.
I use Excel 2010. Not sure what others use but the excel graph needs to show probably on all main current versions of Excecl

Does someone know the cause of the problem and the best way to resolve.
Graph-Issue.xlsx
SpreadsheetsMicrosoft Excel

Avatar of undefined
Last Comment
gh_user

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Wayne Taylor (webtubbs)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
gh_user

ASKER
Thanks Wayne.  Is there a way of specifying an export to be in Excel 2010?
Wayne Taylor (webtubbs)

It'll depend on the program and if it is specifically referencing XL2013. If it's not, it should use the version installed on the computer the software is run on.
gh_user

ASKER
Hi Wayne.  
1/ If the software saved as .xls rather than .xlsx file, might that work
2/ With the fix you mention above about resetting label text, there are no options to show the point name (which is A, B, ...).  Any suggestions?
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
SOLUTION
Wayne Taylor (webtubbs)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
gh_user

ASKER
Thanks Wayne for promptly addressing follow-up questions