Chart Wizard not so wizardy

Discuss the spreadsheet application

Chart Wizard not so wizardy

Postby jans » Sat Jul 14, 2018 8:27 am

I have two Calc columns of information. I want a column-style chart showing the first column of info (on my sheet) as the x (horizontal) axis, and the second column of info as the y (vertical) axis. The y axis should be showing percentage values, which means the numbers should go up to 100, or at least the highest value in my data set.

In a wizard, selecting both columns together, then generating a chart from it should display a chart that shows that information. It should display it in any chart format I choose. And the entire process should take about half a minute.

Instead I get a chart which shows values that are not even in my data. Eg., a y axis that shows values up to 12 (?) and an x axis that seems to want to show the sheet row count.

Where is the '12' coming from? There is no value or quantity of 12 in my data set.
open office 4.11 Win 7
jans
 
Posts: 2
Joined: Thu Oct 22, 2015 7:05 am

Re: Chart Wizard not so wizardy

Postby Zizi64 » Sat Jul 14, 2018 9:39 am

Please upload your ODF type sample file here.
Tibor Kovacs, Hungary; LO4.4.7, LO5.4.7 on Win7x64Prof.
PortableApps, winPenPack: LO3.3.0-LO6.1.0 and AOO4.1.5
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 7192
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Chart Wizard not so wizardy

Postby FJCC » Sat Jul 14, 2018 4:32 pm

I agree an example file would be very helpful. Without one, my first guess is that on the second page of the wizard you need to select First Column as Label
AOO 3.4 or 4.1 on MS Windows XP ( before 2013-08-03) or Windows 7
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 6711
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA


Return to Calc

Who is online

Users browsing this forum: Google [Bot] and 21 guests