OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Mixed bar/line chart types

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
maxqnz
Super User
Super User


Joined: 24 Mar 2003
Posts: 1290
Location: Te Ika a Maui, Aotearoa

PostPosted: Tue Oct 07, 2003 2:56 am    Post subject: Mixed bar/line chart types Reply with quote

Here is my question: I have a chart that looks like this in Quattro Pro.

Now, when I attempt to create a mixed lline & bar chart in Calc, the only option I can find is a stacked bar & line chart that ends up looking like this

I was impressed with how easy it was to change to the mixed line bar format in Calc, and think the "n" number of lines system, automagically assigning the last "n" series to line format, is great. However, I don't want to be forced to use a stacked bar with the lines. Is this possible in Calc?
_________________
Noho ora mai, ka kite ano.
What Is A Pieriansipist?

OOo 2.4/XP Pro SP2 / OOo 2.3.0.1/OpenSuse 10.3
Back to top
View user's profile Send private message Visit poster's website
lestat99
Guest





PostPosted: Wed Jan 28, 2004 1:52 pm    Post subject: I'm having a problem doing this AT ALL Reply with quote

I cannot even create a MIXED line / bar graph... I'm still looking but WOW.. real snag.

I am trying to create a mixed line / bar graph.

the X axis is "weeks"

the Y axis is

amount 1

amount 2

amount 3.

I want 1 and 2 to show up as lines and amount 3 to show up as a bar chart.. In microsoft I just have to right click the line of choice and pick bar graph and JUST THAT INFO CHANGES
Back to top
dfrench
Moderator
Moderator


Joined: 03 Mar 2003
Posts: 1605
Location: Wellington, New Zealand

PostPosted: Wed Jan 28, 2004 2:53 pm    Post subject: Reply with quote

Is this possible in Calc?
Yes Max, I see 5 variants of the Column chart , the 4th one is Combination chart Lines and Columns. You will need to order your data columns into Columns first then Lines.
Quote:
In microsoft I just have to right click the line of choice and pick bar graph and JUST THAT INFO CHANGES
You are not in Kansas, now Lestat99 Smile
Can't do Bars(horizontal) and Lines; only Columns(vertical) and Lines

There is a lot of work going on to redevelop the charting functionality see http://graphics.openoffice.org/chart/chart.html
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group