+ Reply to Thread
Results 1 to 4 of 4

How to change horizontal category on a data series or manually create a legend

  1. #1
    Registered User
    Join Date
    03-11-2019
    Location
    Sweden
    MS-Off Ver
    Office 365
    Posts
    12

    How to change horizontal category on a data series or manually create a legend

    Hi,
    So I had trouble formulating a title for my problem, but perhaps it is easier to explain with a picture of my graph.

    Namnlös.png

    This is how it currently looks, but I want the green bar to be in experiment 2 and not in experiment 1 while still having 3 legends.

    Namnlös 1.png

    This is how I want it to look, but of course more professional-looking. I would prefer it without the weird invisible bar in experiment 1. By "cheating" this way the spacing between the bars is also off.

    I currently have three data series and two "horizontal categories". One of the data series are composed of two values, which I want to be under both categories. The other two data series are only composed of a single value, and I want one of them to be under the first horizontal category and the other under the second. I've thought about trying to manually change the horizontal category it is in, but to no avail. If I could manually create just a legend with no data in it that would also solve it. I don't know if it is possible to do either of those though.

    I hope my explanation of my problem is understandable enough, any and all help is appreciated!

    Warm regards,
    Lymoz
    Attached Files Attached Files
    Last edited by Lymoz; 11-30-2020 at 05:08 PM.

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: How to change horizontal category on a data series or manually create a legend

    Although I can not think of a way to produce the chart exactly as you want, perhaps the attached file will give you or one of the other contributors an idea about how to get what you want.
    1. Produce a pivot table with Experiment and Inkubation placed in the Rows area and Differens (Average of) in the Values field
    2. Produce a pivot chart from the pivot table.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    03-11-2019
    Location
    Sweden
    MS-Off Ver
    Office 365
    Posts
    12

    Re: How to change horizontal category on a data series or manually create a legend

    This will do just fine, thank you very much for the help!

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: How to change horizontal category on a data series or manually create a legend

    You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to change the horizontal axis and legend in a bar chart?
    By IvyAurora in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-16-2019, 04:33 PM
  2. Arrange set of data from vetical to horizontal by category
    By whallak in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-18-2019, 06:53 AM
  3. [SOLVED] change legend of chart with multiple series
    By qzlvyh0524 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-06-2018, 07:58 PM
  4. How can I quickly change the Series names in the legend?
    By dmasters4919 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-13-2015, 09:50 AM
  5. Replies: 1
    Last Post: 12-12-2012, 10:50 PM
  6. How do you change the legend from series to an actual value?
    By jackofalltrades in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-04-2012, 02:47 AM
  7. [SOLVED] [SOLVED] Hiding data series in legend
    By RED in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-08-2006, 12:10 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1