Charts

I have a traffic chart showing weekly traffic in columns, web traffic and
sales on lines. Problem is I need to add horizontal columns showing other
data. Can this be done? I have these horizonal columns inserted now as
drawn in boxes, but as my dates shift the boxes shift.
--
Pam K.

Have you tried some of the Custom Types chart on the Custom Types tab of the
Chart Wizard?



"Buckeye Fanatic" wrote:

> I have a traffic chart showing weekly traffic in columns, web traffic and
> sales on lines. Problem is I need to add horizontal columns showing other
> data. Can this be done? I have these horizonal columns inserted now as
> drawn in boxes, but as my dates shift the boxes shift.
> --
> Pam K.

On Fri, 16 Nov 2007, in microsoft.public.excel.charting,
Buckeye Fanatic <BuckeyeFanatic@discussions.microsoft.com> said:

>I have a traffic chart showing weekly traffic in columns, web traffic and
>sales on lines. Problem is I need to add horizontal columns showing other
>data. Can this be done?

I believe so. I just tested it out on my Excel (97), and succeeded very
quickly in turning three column series into one columns, one lines, and
one horizontal bars.

Don't worry if you can't find this built in as a system; just start from
one type, then change the series types individually by right-clicking on
a series and selecting "Chart Type".

--
Del Cotter
NB Personal replies to this post will send email to del@branta.demon.co.uk,
which goes to a spam folder-- please send your email to del3 instead.