• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1214
  • Last Modified:

Can't convert 123 graph to MS Excel

Hello there,

I have about 25 graph (line graph) in my Lotus Smarsuite 97 (.123 format) and would to open in MS Excel. First MS Excel prompt can't open 123 format file, so I save as type WK4 file format and Excel managed to open the file without change any data or the format.  

But when came to the graph, it go unformatted or 'go crazy' format that required to reconfigure the graph.  The graph design with 123 Wizards help.

Please advise or help me how to get back the graph format and design found in my 123 file in my new Excel file.  Many thanks.

Cheers.

0
rajini88
Asked:
rajini88
  • 2
  • 2
  • 2
1 Solution
 
patrickabCommented:
I have an even older edition of Lotus123 but I cannot get it to save a chart which is viewable in Excel. Dunno how to help.
0
 
rajini88Author Commented:
Can other tools or softwarre help users to convert this chart to MS Excel chart without losing the format , style or design.

Please advise, since this not just safe time, but prevent any mistakes in data or graph creation.

Many thanks.

0
 
patrickabCommented:
rajini88,

The safest and quickest method is most probably to copy all the raw data into an Excel spreadsheet and re-create the charts in Excel. The Excel charting wizard is quick and relatively easy to use. Personally that is what I would do - even for 25 charts as I reckon that in one morning at the very least I'd have the job done.

Patrick

0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
RanjeetRainCommented:
If you would like, see if these guys can help: http://www.convertertechnology.com/expertise.cfm?ID=111

You may also see suggestions in this thread: http://www.experts-exchange.com/Applications/Lotus_Smart_Suite/Q_21030166.html
0
 
rajini88Author Commented:
Hi RanjeeRain,

Thanks for the suggestion and the second suggestion works may works since I was told by my support that MS Office XP can't open or load most of Lotus 123 older ver format.

Many thanks.

p/s: Thanks to you also, Patrickab.  Cheers.

0
 
RanjeetRainCommented:
Glad to help!
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 2
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now