Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 21
Default Floating Bars on Line-Bar Charts?

I'm using Excel 2003. I want to creat several bars on a Line-Bar chart that
begin above the X axis. Example: scale is 0 to 4000. Several lines are
plotted but a few bars are need that start at numbers like 1200 to 3500; the
bottom of the bar is at 1200 and the top is at 3500. Can someone give me a
thumbnail on how to do this or poit me to a reference please.


  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 560
Default Floating Bars on Line-Bar Charts?

On Mon, 16 Jul 2007, in microsoft.public.excel.charting,
jaygreg said:
I'm using Excel 2003. I want to creat several bars on a Line-Bar chart that
begin above the X axis. Example: scale is 0 to 4000. Several lines are
plotted but a few bars are need that start at numbers like 1200 to 3500; the
bottom of the bar is at 1200 and the top is at 3500. Can someone give me a
thumbnail on how to do this or poit me to a reference please.


Make a Stacked Column type of chart, with the first bar being 1200 and
the second bar being 3500-1200=2300. Then format the lower bar so that
it has no line and no fill. Now it's invisible, so the top bar looks as
though it's floating in air.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.
  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Floating Bars on Line-Bar Charts?

What Del forgot to tell you was to ignore the built-in custom chart types
and construct your own combination chart. After you get the floating columns
looking right, add another series with the line data, which adds another
column on the stack. Select the new series, go to Chart menu Chart Type,
and select the Line chart subtype you want.

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


"Del Cotter" wrote in message
...
On Mon, 16 Jul 2007, in microsoft.public.excel.charting,
jaygreg said:
I'm using Excel 2003. I want to creat several bars on a Line-Bar chart
that
begin above the X axis. Example: scale is 0 to 4000. Several lines are
plotted but a few bars are need that start at numbers like 1200 to 3500;
the
bottom of the bar is at 1200 and the top is at 3500. Can someone give me a
thumbnail on how to do this or poit me to a reference please.


Make a Stacked Column type of chart, with the first bar being 1200 and the
second bar being 3500-1200=2300. Then format the lower bar so that it has
no line and no fill. Now it's invisible, so the top bar looks as though
it's floating in air.

--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3 instead.



  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 21
Default Floating Bars on Line-Bar Charts?

Thanks guys. I'll give it a try.

"Jon Peltier" wrote in message
...
What Del forgot to tell you was to ignore the built-in custom chart types
and construct your own combination chart. After you get the floating
columns looking right, add another series with the line data, which adds
another column on the stack. Select the new series, go to Chart menu
Chart Type, and select the Line chart subtype you want.

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


"Del Cotter" wrote in message
...
On Mon, 16 Jul 2007, in microsoft.public.excel.charting,
jaygreg said:
I'm using Excel 2003. I want to creat several bars on a Line-Bar chart
that
begin above the X axis. Example: scale is 0 to 4000. Several lines are
plotted but a few bars are need that start at numbers like 1200 to 3500;
the
bottom of the bar is at 1200 and the top is at 3500. Can someone give me
a
thumbnail on how to do this or poit me to a reference please.


Make a Stacked Column type of chart, with the first bar being 1200 and
the second bar being 3500-1200=2300. Then format the lower bar so that it
has no line and no fill. Now it's invisible, so the top bar looks as
though it's floating in air.

--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3 instead.





  #5   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 21
Default Floating Bars on Line-Bar Charts?

Hummmmm. More puzzling than I anticipated. When I use the wizzard and try to
change just the columns I want to make into dtacked bars, I can't find
anything that controls just that set of data for the one year in question.
When I attempt to follow your direction, |Jon, I have trouble understanding
how I'm to proceedwithout that wizzard. I used the F11 key after reading
HELP but that was no help. I still can't control the one or two years I
want.

There are about a dozen series; two of these will be stacked columns and the
remaining 10 line type. I can't find a way to mix the types. I see two axes
charts but that still would let me stack the columns on one axes then draw
the lines on the other... or will it?

"jaygreg" wrote in message
...
Thanks guys. I'll give it a try.

"Jon Peltier" wrote in message
...
What Del forgot to tell you was to ignore the built-in custom chart

types
and construct your own combination chart. After you get the floating
columns looking right, add another series with the line data, which adds
another column on the stack. Select the new series, go to Chart menu
Chart Type, and select the Line chart subtype you want.

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


"Del Cotter" wrote in message
...
On Mon, 16 Jul 2007, in microsoft.public.excel.charting,
jaygreg said:
I'm using Excel 2003. I want to creat several bars on a Line-Bar chart
that
begin above the X axis. Example: scale is 0 to 4000. Several lines are
plotted but a few bars are need that start at numbers like 1200 to

3500;
the
bottom of the bar is at 1200 and the top is at 3500. Can someone give

me
a
thumbnail on how to do this or poit me to a reference please.

Make a Stacked Column type of chart, with the first bar being 1200 and
the second bar being 3500-1200=2300. Then format the lower bar so that

it
has no line and no fill. Now it's invisible, so the top bar looks as
though it's floating in air.

--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3

instead.








  #6   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 21
Default Floating Bars on Line-Bar Charts?

Spoke too soon. Found that by double-clicking a bar and selecting the entire
series, I can chage the chart typefor just that series. Problem now will by
the year 2006. There are four entries for that year but only two will be
used to create a stacked cloumn. Problem is... all four want to clime on top
of one another. Any way to just select two of the four for one year?

"jaygreg" wrote in message
...
Hummmmm. More puzzling than I anticipated. When I use the wizzard and try

to
change just the columns I want to make into dtacked bars, I can't find
anything that controls just that set of data for the one year in question.
When I attempt to follow your direction, |Jon, I have trouble

understanding
how I'm to proceedwithout that wizzard. I used the F11 key after reading
HELP but that was no help. I still can't control the one or two years I
want.

There are about a dozen series; two of these will be stacked columns and

the
remaining 10 line type. I can't find a way to mix the types. I see two

axes
charts but that still would let me stack the columns on one axes then draw
the lines on the other... or will it?

"jaygreg" wrote in message
...
Thanks guys. I'll give it a try.

"Jon Peltier" wrote in message
...
What Del forgot to tell you was to ignore the built-in custom chart

types
and construct your own combination chart. After you get the floating
columns looking right, add another series with the line data, which

adds
another column on the stack. Select the new series, go to Chart menu
Chart Type, and select the Line chart subtype you want.

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


"Del Cotter" wrote in message
...
On Mon, 16 Jul 2007, in microsoft.public.excel.charting,
jaygreg said:
I'm using Excel 2003. I want to creat several bars on a Line-Bar

chart
that
begin above the X axis. Example: scale is 0 to 4000. Several lines

are
plotted but a few bars are need that start at numbers like 1200 to

3500;
the
bottom of the bar is at 1200 and the top is at 3500. Can someone give

me
a
thumbnail on how to do this or poit me to a reference please.

Make a Stacked Column type of chart, with the first bar being 1200

and
the second bar being 3500-1200=2300. Then format the lower bar so

that
it
has no line and no fill. Now it's invisible, so the top bar looks as
though it's floating in air.

--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3

instead.








  #7   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Floating Bars on Line-Bar Charts?

I'm not really clear on what you're trying to do...

You can change one series at a time, the entire series. If 'the year 2006'
indicates a series, then select the series and change its attributes. If
'the year 2006' indicates a label on the category (X) axis (i.e., one point
in each series), you can't change the series type of just one point in a
series, but you could select the series then select the point, then change
formatting of that point.

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


"jaygreg" wrote in message
...
Spoke too soon. Found that by double-clicking a bar and selecting the
entire
series, I can chage the chart typefor just that series. Problem now will
by
the year 2006. There are four entries for that year but only two will be
used to create a stacked cloumn. Problem is... all four want to clime on
top
of one another. Any way to just select two of the four for one year?

"jaygreg" wrote in message
...
Hummmmm. More puzzling than I anticipated. When I use the wizzard and try

to
change just the columns I want to make into dtacked bars, I can't find
anything that controls just that set of data for the one year in
question.
When I attempt to follow your direction, |Jon, I have trouble

understanding
how I'm to proceedwithout that wizzard. I used the F11 key after reading
HELP but that was no help. I still can't control the one or two years I
want.

There are about a dozen series; two of these will be stacked columns and

the
remaining 10 line type. I can't find a way to mix the types. I see two

axes
charts but that still would let me stack the columns on one axes then
draw
the lines on the other... or will it?

"jaygreg" wrote in message
...
Thanks guys. I'll give it a try.

"Jon Peltier" wrote in message
...
What Del forgot to tell you was to ignore the built-in custom chart

types
and construct your own combination chart. After you get the floating
columns looking right, add another series with the line data, which

adds
another column on the stack. Select the new series, go to Chart menu

Chart Type, and select the Line chart subtype you want.

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


"Del Cotter" wrote in message
...
On Mon, 16 Jul 2007, in microsoft.public.excel.charting,
jaygreg said:
I'm using Excel 2003. I want to creat several bars on a Line-Bar

chart
that
begin above the X axis. Example: scale is 0 to 4000. Several lines

are
plotted but a few bars are need that start at numbers like 1200 to

3500;
the
bottom of the bar is at 1200 and the top is at 3500. Can someone
give

me
a
thumbnail on how to do this or poit me to a reference please.

Make a Stacked Column type of chart, with the first bar being 1200

and
the second bar being 3500-1200=2300. Then format the lower bar so

that
it
has no line and no fill. Now it's invisible, so the top bar looks as
though it's floating in air.

--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3

instead.










  #8   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 21
Default Floating Bars on Line-Bar Charts?

Jon, here's more data:

Objective: Plot three types of medical expenses as lines on a chart having a
time from 1995 to 2006. For 2007 and beyond, these lines - when data is
available - will penetrate a stacked bar representing at the very top, the
maximum amount of "out-of pocket" charges and at the bottom of this floating
bar, the total amount paid for insurance premiums.



That year 2007 has three bars associated with it; the only bars on the chart
now that I learned how to change the others to lines. Those three bars (the
3rd represnts the out-of-pocket of a competing insuracne plan) are giving me
a headache. I can't seem to find a way to stack them... at least two of
them.





"Jon Peltier" wrote in message
...
I'm not really clear on what you're trying to do...

You can change one series at a time, the entire series. If 'the year 2006'
indicates a series, then select the series and change its attributes. If
'the year 2006' indicates a label on the category (X) axis (i.e., one
point in each series), you can't change the series type of just one point
in a series, but you could select the series then select the point, then
change formatting of that point.

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


"jaygreg" wrote in message
...
Spoke too soon. Found that by double-clicking a bar and selecting the
entire
series, I can chage the chart typefor just that series. Problem now will
by
the year 2006. There are four entries for that year but only two will be
used to create a stacked cloumn. Problem is... all four want to clime on
top
of one another. Any way to just select two of the four for one year?

"jaygreg" wrote in message
...
Hummmmm. More puzzling than I anticipated. When I use the wizzard and
try

to
change just the columns I want to make into dtacked bars, I can't find
anything that controls just that set of data for the one year in
question.
When I attempt to follow your direction, |Jon, I have trouble

understanding
how I'm to proceedwithout that wizzard. I used the F11 key after reading
HELP but that was no help. I still can't control the one or two years I
want.

There are about a dozen series; two of these will be stacked columns and

the
remaining 10 line type. I can't find a way to mix the types. I see two

axes
charts but that still would let me stack the columns on one axes then
draw
the lines on the other... or will it?

"jaygreg" wrote in message
...
Thanks guys. I'll give it a try.

"Jon Peltier" wrote in message
...
What Del forgot to tell you was to ignore the built-in custom chart
types
and construct your own combination chart. After you get the floating
columns looking right, add another series with the line data, which

adds
another column on the stack. Select the new series, go to Chart menu

Chart Type, and select the Line chart subtype you want.

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


"Del Cotter" wrote in message
...
On Mon, 16 Jul 2007, in microsoft.public.excel.charting,
jaygreg said:
I'm using Excel 2003. I want to creat several bars on a Line-Bar

chart
that
begin above the X axis. Example: scale is 0 to 4000. Several lines

are
plotted but a few bars are need that start at numbers like 1200 to
3500;
the
bottom of the bar is at 1200 and the top is at 3500. Can someone
give
me
a
thumbnail on how to do this or poit me to a reference please.

Make a Stacked Column type of chart, with the first bar being 1200

and
the second bar being 3500-1200=2300. Then format the lower bar so

that
it
has no line and no fill. Now it's invisible, so the top bar looks
as
though it's floating in air.

--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3
instead.












  #9   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Floating Bars on Line-Bar Charts?

I think if you pasted your data in a reply it would be easier to see what
you need to do.

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


"jaygreg" wrote in message
...
Jon, here's more data:

Objective: Plot three types of medical expenses as lines on a chart having
a time from 1995 to 2006. For 2007 and beyond, these lines - when data is
available - will penetrate a stacked bar representing at the very top, the
maximum amount of "out-of pocket" charges and at the bottom of this
floating bar, the total amount paid for insurance premiums.



That year 2007 has three bars associated with it; the only bars on the
chart now that I learned how to change the others to lines. Those three
bars (the 3rd represnts the out-of-pocket of a competing insuracne plan)
are giving me a headache. I can't seem to find a way to stack them... at
least two of them.





"Jon Peltier" wrote in message
...
I'm not really clear on what you're trying to do...

You can change one series at a time, the entire series. If 'the year
2006' indicates a series, then select the series and change its
attributes. If 'the year 2006' indicates a label on the category (X) axis
(i.e., one point in each series), you can't change the series type of
just one point in a series, but you could select the series then select
the point, then change formatting of that point.

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


"jaygreg" wrote in message
...
Spoke too soon. Found that by double-clicking a bar and selecting the
entire
series, I can chage the chart typefor just that series. Problem now will
by
the year 2006. There are four entries for that year but only two will be
used to create a stacked cloumn. Problem is... all four want to clime on
top
of one another. Any way to just select two of the four for one year?

"jaygreg" wrote in message
...
Hummmmm. More puzzling than I anticipated. When I use the wizzard and
try
to
change just the columns I want to make into dtacked bars, I can't find
anything that controls just that set of data for the one year in
question.
When I attempt to follow your direction, |Jon, I have trouble
understanding
how I'm to proceedwithout that wizzard. I used the F11 key after
reading
HELP but that was no help. I still can't control the one or two years I
want.

There are about a dozen series; two of these will be stacked columns
and
the
remaining 10 line type. I can't find a way to mix the types. I see two
axes
charts but that still would let me stack the columns on one axes then
draw
the lines on the other... or will it?

"jaygreg" wrote in message
...
Thanks guys. I'll give it a try.

"Jon Peltier" wrote in message
...
What Del forgot to tell you was to ignore the built-in custom chart
types
and construct your own combination chart. After you get the
floating
columns looking right, add another series with the line data, which
adds
another column on the stack. Select the new series, go to Chart
menu
Chart Type, and select the Line chart subtype you want.

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


"Del Cotter" wrote in message
...
On Mon, 16 Jul 2007, in microsoft.public.excel.charting,
jaygreg said:
I'm using Excel 2003. I want to creat several bars on a Line-Bar
chart
that
begin above the X axis. Example: scale is 0 to 4000. Several lines
are
plotted but a few bars are need that start at numbers like 1200 to
3500;
the
bottom of the bar is at 1200 and the top is at 3500. Can someone
give
me
a
thumbnail on how to do this or poit me to a reference please.

Make a Stacked Column type of chart, with the first bar being 1200
and
the second bar being 3500-1200=2300. Then format the lower bar so
that
it
has no line and no fill. Now it's invisible, so the top bar looks
as
though it's floating in air.

--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3
instead.














Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Floating bars Songoku Charts and Charting in Excel 1 July 21st 06 01:48 PM
Make a line in a bar chart, and change color of any bars that exceed the line MarkM Excel Discussion (Misc queries) 4 July 5th 06 04:06 PM
How can I change a graph with 2 bars,2 lines to 3 bars, 1 line? IOWAJulie Charts and Charting in Excel 3 October 19th 05 11:13 PM
Floating Bars Songoku Charts and Charting in Excel 8 June 8th 05 05:41 AM
How do I create a bar graph with floating bars? Rocco Charts and Charting in Excel 1 January 12th 05 07:26 PM


All times are GMT +1. The time now is 10:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"