Converting Lotus 1-2-3 charts to Excel

  • Thread starter Thread starter Cas Nowak
  • Start date Start date
C

Cas Nowak

I am in the process of converting Lotus 1-2-3
spreadsheets which have charts in them to Excel.
After starting Excel and opening the Lotus file in Excel.
I do a 'save as' and give it the workbook format.
The charts look almost identical. I had to change
colors, change some ranges, etc. The one thing I can not
figure out is the following:

The original Lotus file had the years 1992 through 2003
on the Y-axis. The bar for 1992 was directly above the
1992 and indented about 1/2 inch from the vertcal x-axis.

In Excel the chart has the years 1992 through 2003 on the
Y-axis BUT the bar for 1992 IS directly on the far right
X-axis bar and NOT indented the 1/2 inch from the vertcal
x-axis.

There is a bar for each month so I also want a vertical
grid on January and one on December,so the years can be
seen easy.

Is there a way in Excel to move the bars from being
directly next to the X-axis and the then move the Y-axis
years to be directly under the years.

EXAMPLE:This is how it converted with 1992 and bar next
to x-axis.

5|b
3|a
0|r__________
-3|
-5|
|_______________
1992 1993

EXAMPLE:would like 1992 and bar indented about 1/2 from x-
axis. and a grid to identfy the beginning of 1992 and end
of 1992. (or start of 1993)
5| b
3| a
0| r______________
-3| | |
-5| | |
|__________________
1992 1993
 
Cas -

I think if you double click on the X axis (the years), and click on the
scale tab, if you check the "Axis Crosses Between Categories" box, it
might give you what you want. If not, there might be some missing
details, so post back.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Jon,
I did have that box checked. Checking & unchecking just
moves the bars closer together then further apart. It is
a very small amount of change.
Problem still exists.
Cas
 
Has Excel decided to make you a time scale axis rather than a category
axis? Double click on the axis and click on the scale tab. Does it say
Category (X) Axis Scale or Time (X) Axis Scale at the top? To change
this, choose Chart Options from the Chart menu, click on the Axes tab,
and change from Automatic to the type you don't currently have.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top