Charting Lines and Bars on Same Graph

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David - 30 Oct 2003 16:36 GMT

I am having trouble charting a Quarterly Revenue Graph
with Lines and Bars on same graph.
I would like Revenue on Y Axis and Quarters on X Axis. I
would like 2 base series as bars and 6 other series as
lines.
Any idea how to do that? (i'm in Excel 2000)

I have gone to the chart wizard and chosen "Custom Types"
and then "Line-Column". This automtically selects the
first four in the series as bars and last 4 as lines. I
would like only the first two as bars.

Thank you!!!

Reply to this Message

Jon Peltier - 30 Oct 2003 18:04 GMT

David -

Chart all eight series as lines. Select one to change to columns,
choose Chart Type from the Chart menu, and select a Column style.
Select the other one to change, and press F4 to repeat, for clustered
columns. If you want stacked columns, for the second return to the
Chart Type dialog, and select the Stacked Column. (Even if you pick
Stacked Column for the first changed series, Excel only remembers
Column, and reverts to Clustered when you hit F4.)

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

> I am having trouble charting a Quarterly Revenue Graph
> with Lines and Bars on same graph.
[quoted text clipped - 9 lines]
>
> Thank you!!!

Reply to this Message

dvt - 30 Oct 2003 18:07 GMT

> I am having trouble charting a Quarterly Revenue Graph
> with Lines and Bars on same graph.
[quoted text clipped - 7 lines]
> first four in the series as bars and last 4 as lines. I
> would like only the first two as bars.

Take your chart with 4 lines and 4 bars as a starting point. Select one
of the series you'd like to convert from bars to lines by clicking on one
of the bars. Go to the menu and click Chart | Chart type | pick your
favorite line type. Repeat the conversion procedure with the other series.

Signature

Dave
dvt at psu dot edu

Reply to this Message