Graph Manipulation
 

Hello all - I am have some data that I would like to display in a
grapy format. Most of the data is percentage type but one column is
actual data. For this reason I have chosen a custom type, Line -
column on 2 axes. This causes some of the data to be displayed as bars
and some as lines. I can move the data from one axes to another but
cannot determine how to change a bar to a line. Can anyone help out
with this? How do I change a bar in a line - column on 2 axes graph to
a line and vice versa?
Thanks in advance.
Terry

Graph Manipulation
 

Terry,

You can select any series, be it a line series, bar or column series, then change it to one
other of line, bar or column. To do that, right click it, choose Chart Type, and change it.
The change will apply only to that series.

--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
wrote in message
oups.com...
Hello all - I am have some data that I would like to display in a
grapy format. Most of the data is percentage type but one column is
actual data. For this reason I have chosen a custom type, Line -
column on 2 axes. This causes some of the data to be displayed as bars
and some as lines. I can move the data from one axes to another but
cannot determine how to change a bar to a line. Can anyone help out
with this? How do I change a bar in a line - column on 2 axes graph to
a line and vice versa?
Thanks in advance.
Terry

Graph Manipulation
 

On Aug 24, 11:04 am, "Earl Kiosterud" wrote:
Terry,

You can select any series, be it a line series, bar or column series, then change it to one
other of line, bar or column. To do that, right click it, choose Chart Type, and change it.
The change will apply only to that series.

--
Earl Kiosterudwww.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
wrote in message

oups.com...



Hello all - I am have some data that I would like to display in a
grapy format. Most of the data is percentage type but one column is
actual data. For this reason I have chosen a custom type, Line -
column on 2 axes. This causes some of the data to be displayed as bars
and some as lines. I can move the data from one axes to another but
cannot determine how to change a bar to a line. Can anyone help out
with this? How do I change a bar in a line - column on 2 axes graph to
a line and vice versa?
Thanks in advance.
Terry- Hide quoted text -

- Show quoted text -

You have no idea how much that helped. Thank you very much and have a
GREAT day.
PS: I really feel very intellectually challenged right now