Graph Manipulation

J

jtkinsella

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
 
E

Earl Kiosterud

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

jtkinsella

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





- 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
 

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

Top