[Solved] Creating a Timeline with Scatter and data labels

Discuss the spreadsheet application

[Solved] Creating a Timeline with Scatter and data labels

Postby mamba » Thu Jul 08, 2010 11:15 am

Trying to create a timeline in the same way you can with Excel in this article.

Is should look something like this:
Timeline-for-Benjamin-Franklin.gif

I can get most of the way there, but I cannot get Calc to use a non-x, non-y column for data labels. If I say insert data labels, I end up with a numeric value.

Someone else tried it with OO here, but it still does not work for me:
http://ubuntuforums.org/showthread.php?t=715878

The attached XLS Excel file should look like the chart above, but as soon as you try to edit it in OO, the data labels change to numbers.
Attachments
Excel-Timeline-Template.xls
(54 KiB) Downloaded 2753 times
Last edited by Hagar Delest on Thu Jul 08, 2010 9:24 pm, edited 1 time in total.
Reason: tagged [Solved].
OpenOffice 4.1.2 on Windows 10 64-bit
User avatar
mamba
 
Posts: 6
Joined: Thu Jul 08, 2010 11:06 am

Re: Creating a Timeline with Scatter and data labels

Postby jrkrideau » Thu Jul 08, 2010 11:25 am

Try inserting the data labels using INSERT in the tool bar rather than right clicking.
OpenOffice 4.1.6; Ubuntu 18.04
jrkrideau
Volunteer
 
Posts: 3690
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada

Re: Creating a Timeline with Scatter and data labels

Postby mamba » Thu Jul 08, 2010 11:40 am

Doesn't work. Try it yourself.
OpenOffice 4.1.2 on Windows 10 64-bit
User avatar
mamba
 
Posts: 6
Joined: Thu Jul 08, 2010 11:06 am

Re: Creating a Timeline with Scatter and data labels

Postby Hagar Delest » Thu Jul 08, 2010 1:46 pm

Seems to work fine on W2k with the tutorial from the Ubuntu forum, see attachment:
Excel-Timeline-Template.ods
(48.71 KiB) Downloaded 3766 times

If something doesn't work in Ubuntu but does with Windows, try the Sun/Oracle version: [Ubuntu] Installing OOo on Debian and Co.

Thanks to add '[Solved]' at beginning of your first post title (edit button) if your issue has been fixed.
AOO 4.1.6 on Xubuntu 19.04 and 4.1.5 on Windows 7 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28495
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Creating a Timeline with Scatter and data labels

Postby mamba » Thu Jul 08, 2010 3:57 pm

That's excellent. Did you do that by making the data labels "categories"?
OpenOffice 4.1.2 on Windows 10 64-bit
User avatar
mamba
 
Posts: 6
Joined: Thu Jul 08, 2010 11:06 am

Re: Creating a Timeline with Scatter and data labels

Postby Hagar Delest » Thu Jul 08, 2010 5:10 pm

Yes. So the procedure should be:
0. Select B5-B19, hold Ctrl and select E5-E19
1. Start chart wizard
2. Step 1: Select XY scatter (next)
3. Step 2: Unselect First row as label, unselect First column as label (next)
4. Step 3: Data labels, select C5-C19 (next)
5. Step 4: Add title, unselect Display legend and unselect Y axis grid (finish)
6. Right click one of the data points(yellow triangle), insert data labels
7. Double-click a label, unselect Show value as number, select Show category, select Placement: right
8. Right click a data point to select the series and Insert Error Bars
9. Select the Negative option and set Percentage to 100
9. Right click the whole chart, Insert/Delete Axes and unselect the Y axis.

Thanks to add '[Solved]' at beginning of your first post title (edit button) if your issue has been fixed.
AOO 4.1.6 on Xubuntu 19.04 and 4.1.5 on Windows 7 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28495
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Creating a Timeline with Scatter and data labels

Postby acknak » Thu Jul 08, 2010 5:40 pm

Hey, that's a pretty twisted way to plot a timeline--I like it!

There does seem to be one glitch that I don't understand: if I open Hagar's sample .ods, activate the first chart, that shows the number labels, and do...

1) Right-click on a data label > Format Data Labels > Data Labels
___Show value as a number: NO
___Show category: YES
___OK (labels disappear)
2) Right-click anywhere > Data Ranges > Data Series
___Click the "Shrink" button to the right of "Data Labels" then select C5:C19
___OK

Then, I get the event labels.

If I open mamba's .xls document, the same steps do not work: I only get the number labels.

Odd. I wonder why Calc behaves differently with what (I assume) is the same object in the two different files?
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Creating a Timeline with Scatter and data labels

Postby Hagar Delest » Thu Jul 08, 2010 9:24 pm

I had noticed it also at first and since it worked with a new chart, I forgot to check that. I just did and found out that the data label field was not set in the data series properties!

That's indeed a very nice way to make a easily configurable timeline.
AOO 4.1.6 on Xubuntu 19.04 and 4.1.5 on Windows 7 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28495
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: [Solved] Creating a Timeline with Scatter and data label

Postby mamba » Fri Jul 09, 2010 10:09 am

Problem: if you have a lot of text as the data label, eg a sentence or two, it is placed on the chart in one loooooooong string, with no wrapping. It's unusable. How can we make it look like the example in the top of this thread, with word wrapping?

I can highlight the label (green box appears), but the box is not manipulable.
OpenOffice 4.1.2 on Windows 10 64-bit
User avatar
mamba
 
Posts: 6
Joined: Thu Jul 08, 2010 11:06 am

Re: [Solved] Creating a Timeline with Scatter and data label

Postby Zizi64 » Fri Jul 09, 2010 11:40 am

Problem: if you have a lot of text as the data label, eg a sentence or two, it is placed on the chart in one loooooooong string, with no wrapping. It's unusable. How can we make it look like the example in the top of this thread, with word wrapping?


Just double click in cell, and hit Ctrl-Enter on text position where you want to wrap it.
Tibor Kovacs, Hungary; LO4.4.7, LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.4; 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: 8053
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: [Solved] Creating a Timeline with Scatter and data label

Postby ken johnson » Fri Jul 09, 2010 11:41 am

Does it wrap inside the chart label if you use Ctrl+Enter (In the cell, not the formula bar input line) to force the text in the label's source cells to use more than one line?
Like this...
Multi-line chart label.ods
(14.87 KiB) Downloaded 1286 times

Ken Johnson
AOO 4.1.3 on Ms Windows 10
Help improve this forum by clicking the EDIT button on your first post then adding "[Solved]" to its heading once a solution to your problem has been provided.
ken johnson
Volunteer
 
Posts: 918
Joined: Sun May 31, 2009 1:35 am
Location: Sydney, Australia

Re: [Solved] Creating a Timeline with Scatter and data label

Postby mamba » Sat Jul 10, 2010 11:19 am

That works. Thank you guys. I'd like to see the data label box with grab handles that can be resized though. Anyone care to nominate this as an enhancement?
OpenOffice 4.1.2 on Windows 10 64-bit
User avatar
mamba
 
Posts: 6
Joined: Thu Jul 08, 2010 11:06 am

Re: [Solved] Creating a Timeline with Scatter and data label

Postby Hagar Delest » Sat Jul 10, 2010 11:48 am

AOO 4.1.6 on Xubuntu 19.04 and 4.1.5 on Windows 7 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28495
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: [Solved] Creating a Timeline with Scatter and data label

Postby lilleguard » Sun Jul 18, 2010 1:00 pm

Is it possible to make this timeline run vertical. Then it wouldn't be necessary to put text in different heights...
Ubuntu 10.04. Openoffice 3.2.
lilleguard
 
Posts: 4
Joined: Sun Jul 18, 2010 12:59 pm

Re: [Solved] Creating a Timeline with Scatter and data label

Postby lilleguard » Sun Jul 18, 2010 1:09 pm

I would like to make a "twitter timeline" by rotating this diagram 90 degrees CW and inverting the timeline so that 1800 is on top and 1700 at the bottom (the most recent on top). Could it be done?
Ubuntu 10.04. Openoffice 3.2.
lilleguard
 
Posts: 4
Joined: Sun Jul 18, 2010 12:59 pm

Re: [Solved] Creating a Timeline with Scatter and data label

Postby lilleguard » Sun Jul 18, 2010 1:19 pm

Wow! It was fairly easy to do these things myself. Only thing i couldn't do was to rotate the whole diagram, but rotating labels and inverting timeline was easy just by rightclicking x-axis and in the first tab check "Turn direction" (or something like that, I use norwegian openoffice), and then move over to the tab named "Labels" and change text direction to 90. You can do the same with the data labels as well!

But somebody know how to rotate the whole diagram? Or is that impossible?
Ubuntu 10.04. Openoffice 3.2.
lilleguard
 
Posts: 4
Joined: Sun Jul 18, 2010 12:59 pm

Re: [Solved] Creating a Timeline with Scatter and data label

Postby Hagar Delest » Sun Jul 18, 2010 2:02 pm

See how is constructed the diagram and adapt the concept to the other direction.
AOO 4.1.6 on Xubuntu 19.04 and 4.1.5 on Windows 7 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28495
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: [Solved] Creating a Timeline with Scatter and data label

Postby lilleguard » Sun Jul 18, 2010 2:29 pm

Thanks! Made it by swapping x-values with y-values when i created the scatter plot! Great!
Ubuntu 10.04. Openoffice 3.2.
lilleguard
 
Posts: 4
Joined: Sun Jul 18, 2010 12:59 pm

Re: [Solved] Creating a Timeline with Scatter and data label

Postby Ronin » Fri Feb 20, 2015 9:33 pm

...and how to add the duration of an event?
35buk8x.jpg.png
35buk8x.jpg.png (4.96 KiB) Viewed 14635 times
OpenOffice 3.4.1 on Windows 7
Ronin
 
Posts: 13
Joined: Wed Feb 27, 2013 7:58 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 27 guests