Chart help

A

ajr81

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.
 
B

Bernard Liengme

Make a column chart
Right click on the cash balance data series on the chart
Select Chart Type and make Line
best wishes
 
S

ShaneDevenshire

Hi,

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Chart - Excel 2013 - Rotating Second and Third Lines of text onthe Horizontal Axis 0
Excel chart does not start at zero. 1
Bizarre chart behaviour when changing axis cross at points 2
Chart - making positive values into negative ones? 5
Charting: Multiple workbooks one chart 3
Set chart series endpoint dynamically 0
Creating a chart with varying data value ranges 1
Adding lines of data to an area chart 1

Top