View original (French)

Add a secondary axis in libre office excel

gbko Posted messages 568 Registration date   Status Member Last intervention   -  
gbko Posted messages 568 Registration date   Status Member Last intervention   -
Hello,
I can't integrate a secondary axis into my graphs
any help would be greatly appreciated as I have such different values that they don't appear on a single-axis graph.
Thank you
gbko

Configuration: Windows / Edge 88.0.705.50

7 answers

  1.
    m@rina Posted messages 27507 Registration date   Status Moderator Last intervention   11 562
     
    Hello,

    Excel (Microsoft) or Libre Office (Calc)??
    It's either one or the other.

    m@rina

    --
    From now on, if a user tells me "it's not working" without any further information..., I'm giving up!
    0
  2. gbko Posted messages 568 Registration date   Status Member Last intervention   3
     
    Sorry, I meant LibreOffice but I should have said Calc instead of Excel. Does that change the solution to my question much?
    gbko
    0
    1. gbko Posted messages 568 Registration date   Status Member Last intervention   3
       
      In order to group my questions on the Excel or Calc graphic topic, I am attaching my graph on which I would like:
      1_ to succeed in putting the values of the primary and secondary axes side by side in bars rather than stacked
      2_ to be able to see the year 2020 which is still selected in the column captured during the entry
      3_ to be able to move my % labels so that they are all on the same line
      Excuse the old man, but at 88 years old, one often needs help
      Thank you
      gbko


      1
  3. Raymond PENTIER Posted messages 58211 Registration date   Status Contributor Last intervention   17 480
     
    Hello.

    Yes, Excel and Calc have some differences, starting with their ergonomics: layout of tools and icons, dialog boxes, etc.
    Q1: Format data series / Options / Settings / Show bars side by side.
    Q2: Make sure that "Insert X-axis title" is not selected.
    Q3: In Format secondary Y-axis, modify the scale data so that the number of intervals is the same as for the primary axis.

    --
    Retirement is great! Especially in the Caribbean...
    Raymond (INSA, AFPA)
    0
    1. gbko Posted messages 568 Registration date   Status Member Last intervention   3
       
      Thank you very much, Raymond
      I successfully completed points 2 and 3, but not point 1. Where do I click to get "format the series"?
      Just so you know, I use Excel on my laptop (bought Office) and Calc on my desktop PC (downloaded Libre Office), but I get the same result on both.
      Thanks again
      gbko
      0
      1. Raymond PENTIER Posted messages 58211 Registration date   Status Contributor Last intervention   17 480 > gbko Posted messages 568 Registration date   Status Member Last intervention  
         
        Where? The most intuitive and spontaneous: right-click on one of the bars...
        0
  4. gbko Posted messages 568 Registration date   Status Member Last intervention   3
     
    I'm sorry, but despite right-clicking on a series, I can't see the "formatting"
    However, I have the option to adjust the thickness of the bars, but they remain stacked. The only solution is to use the combo chart where I can separate the axes, but the secondary axis only offers me the line, which is better than nothing, but not ideal given the large variations in my data.
    I wonder if my Excel is the right one since I didn't buy the most expensive one by default?
    gbko
    0
  6. Raymond PENTIER Posted messages 58211 Registration date   Status Contributor Last intervention   17 480
     
    * 1) It's not Excel, you specified: It's Calc!
    * 2) In Calc, you must not stay outside the graphic frame, but double-click on the graphic so that Calc's tools become accessible and the elements of the graphic can be modified.
    * 3) It's not the software that should be questioned ...


    --
    Retirement is nice! Especially in the Antilles... Raymond (INSA, AFPA)
    0
    1. gbko Posted messages 568 Registration date   Status Member Last intervention   3
       
      Raymond, thank you again, but as I mentioned earlier, I use Calc on my desktop PC and Excel on my laptop.
      Eureka on Calc:
      I managed to do it through formatting, but on Excel, I can't get it to work; the menu is different, and both axes are taken into account at the beginning, but as soon as I switch to "clustered column", my secondary axis disappears? Where is the mistake?
      Thank you again
      gbko
      0
  7. Raymond PENTIER Posted messages 58211 Registration date   Status Contributor Last intervention   17 480
     
    There is no error ... As indicated in posts #1 and #4, Calc and Excel are not identical.
    In the confusion, I responded for Calc. When you are in Excel, it's different:
    In my example, I started by inserting an empty column between the Y and Z values
    Then I select the data table A1:D6 and I click INSERT/Chart/Clustered Column, then right-click on a bar; I click Format Data Series / Series Options / Primary Axis / Series Overlap -50% / Gap Width 500%. The same for the secondary axis.

    --
    Retirement is nice! Especially in the Caribbean...
    Raymond (INSA, AFPA)
    0
  8. Raymond PENTIER Posted messages 58211 Registration date   Status Contributor Last intervention   17 480
     
    "I can separate the axes, but the secondary one only provides me with the curve, which is better than nothing, but in my case, it's not the best given the large variations in my data."

    If the variations are significant, it is normal, and even desirable, for the graph to reveal this...
    If the variations of the first dataset are less pronounced, you can assign this series to the secondary axis, and the more "erratic" series to the main axis...

    --
    Retirement is great! Especially in the Caribbean...
    Raymond (INSA, AFPA)
    0
    1. gbko Posted messages 568 Registration date   Status Member Last intervention   3
       
      Thank you again
      PHEW I did it! In the end, it's the empty column that does everything to prevent this superposition, so I managed to see the copy.
      But I have seen histograms without space between the bars; how to do that?
      Anyway, for now, everything is fine, that’s enough for me; thanks a thousand times, Raymond
      gbko


      0