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
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
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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.
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?
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?
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks Wayne for promptly addressing follow-up questions
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER