Never mind... got it figured out.
Click on a line on the chart to make the Data Series dialog appear
-
Options – Align data series to
-
Primary Y axis … OR
-
Secondary Y axis
The first trick was to make the DJI line appear, by fiddling with the
Primary Y axis, then was able to align that data series with the Secondary
Y axis. Was able to get the desired chart (also changed Line display for
the DJI to make the chart easier to read).
Cheers,
Jim
On Mon, Aug 12, 2013 at 3:30 PM, Jim Thompson <jthom...@gmail.com> wrote:
> Greetings!
>
> Using LibreOffice Calc – 4.1.0.4
>
>
> Have a fairly simple spreadsheet (just data, no formulas)
>
> -
>
> Column A – Date (e.g., 5.17 = May 17)
> -
>
> Columns B thru E – percentages (range between -6 and +2)
> -
>
> Column F – whole numbers (range between 1450 and 1600)
>
>
> Want to generate a chart (using wizard - and manual tweaking as needed)
>
> -
>
> Chart type – Line – Points and lines (easy to read)
> -
>
> First row as label + First column as label
>
>
> Note the initial results
>
> -
>
> DJI shows changes by date
> -
>
> Other numbers (percentages) are so small they are scrunched into
> virtual invisibility
> -
>
> OK – looks like we need 2 Y axes (one for percentages; one for DJI)
>
>
> Finish initial draft
>
> -
>
> Title – Performance of JFT IRAs + joint account
> -
>
> Subtitle – Compared to TRP benchmarks + DJI
> -
>
> X axis – date
> -
>
> Y axis – % lead
> -
>
> Display legend – Bottom
>
>
> Change primary Y axis (to display percentages)
>
> -
>
> double click on Y Axis
> -
>
> adjust Scale settings
> -
>
> uncheck Automatic for first 3 settings
> -
>
> Minimum -6
> -
>
> Maximum 2
> -
>
> Major interval 1
> -
>
> we now see interesting chart for the 4 percentage columns (by date)
> -
>
> (optional) drag chart to below data, pull bottom right corner to I,50
> (one page on my printer)
>
>
> Can we get DJI onto same chart by fiddling with Secondary Y axis?
>
>
> From menu bar
>
> -
>
> Insert – Axes
> -
>
> Secondary axes – Y axis
>
>
> Change secondary Y axis (attempting to display DJI)
>
> -
>
> double click on Secondary Y axis
> -
>
> adjust Scale settings
> -
>
> uncheck Automatic for first 3 settings
> -
>
> Minimum 14500
> -
>
> Maximum 16000
> -
>
> Major interval 300
>
>
> DJI line not shown. What else is required to display DJI data on same
> chart?
>
> Attached should be 2 Calc spreadsheets...
>
> - jft_ira_performance_graph_data_DJI.ods (just the raw numbers)
>
> - jft_ira_performance_graph_0809_DJI.ods (with half-baked chart)
>
>
> Thanks for any comments or suggestions.
>
>
> Jim
>
>
>
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
