Column and Line Chart

[Nikki]

I am making a Custon Chart using the First -Column and Line Chart. When I
setup the chart it makes the last column a point instead of a column. When I
go in to change the type of Chart it makes the bar much bigger than the
others. I know you can go into Format and decrease/increase width- but I
can't believe there is a not a way to tell excel to make this a column on
setup so they are all uniformly spaced. How does Excel decide whether it is
a point on a line or a bar?

 

[Jon Peltier]

Hi Nikki -

Excel simply splits the number of series between the lines and columns. If you want
to control the chart's appearance, ignore the built in custom types, and make your
own. Start by making a line or column chart, whichever is more prevalent in the
final chart. Say you want five series as columns and one as a line, plot all six
series in a column chart. Select just the series you want to change to a line, and
use Chart Type on the Chart menu to change it. If you need some series on the
secondary axis, double click the series, and on the Axis tab, select Secondary.

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