Results 1 to 4 of 4

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

Threaded View

Lymoz How to change horizontal... 11-24-2020, 03:22 PM
JeteMc Re: How to change horizontal... 11-29-2020, 06:44 PM
Lymoz Re: How to change horizontal... 11-30-2020, 07:11 AM
JeteMc Re: How to change horizontal... 11-30-2020, 01:37 PM
  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.

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] 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