I am trying to make a chart. My first question is-Can you make a chart with
one series of numbers being bars on the chart and a second series being
represented by lines?

In other words, I would like the reveunes for each year to be the bars and
the cash balance per year to be the line. The verticle axis of the chart
would be dollars and the horizontal axis would stager between FY04 Rev, FY04
Cash, FY05 Rev, FY05 Cash.

Does this make sense or do I need to ewxplain it better? Thank you very
much for any help you can provide.

Make a column chart
Right click on the cash balance data series on the chart
Select Chart Type and make Line
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"ajr81" wrote in message
...
I am trying to make a chart. My first question is-Can you make a chart
with
one series of numbers being bars on the chart and a second series being
represented by lines?

In other words, I would like the reveunes for each year to be the bars and
the cash balance per year to be the line. The verticle axis of the chart
would be dollars and the horizontal axis would stager between FY04 Rev,
FY04
Cash, FY05 Rev, FY05 Cash.

Does this make sense or do I need to ewxplain it better? Thank you very
much for any help you can provide.

Hi,

In 2003 you start the chart wizard and in the 1st you choose Custom Types
tab, Line - Column on 2 Axes.

--
Thanks,
Shane Devenshire


"ajr81" wrote:

I am trying to make a chart. My first question is-Can you make a chart with
one series of numbers being bars on the chart and a second series being
represented by lines?

In other words, I would like the reveunes for each year to be the bars and
the cash balance per year to be the line. The verticle axis of the chart
would be dollars and the horizontal axis would stager between FY04 Rev, FY04
Cash, FY05 Rev, FY05 Cash.

Does this make sense or do I need to ewxplain it better? Thank you very
much for any help you can provide.