+ Reply to Thread
Results 1 to 7 of 7

Charts with Data Bands

  1. #1
    Registered User
    Join Date
    11-13-2020
    Location
    Reykjavík, Iceland
    MS-Off Ver
    Excel 365
    Posts
    6

    Question Charts with Data Bands

    Hello!

    I want to add data bands to a chart I've made with Excel. I don't know if data band is the correct term but that is what it's called in another software I'm using (Autocad Civil 3D).
    I've attached an image with similar data bands for reference.

    Is this possible within excel?

    Thanks in advance,
    Þráinn Þ. (Thrainn Th.)
    Attached Images Attached Images

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

    Re: Charts with Data Bands

    Not sure about the 2016 version, however in the 2019 version > select the chart > Chart Tools (tab) > Chart design (sub tab) > Quick Layout > Layout 5.
    If this doesn't help, then please upload a sample .xlsx file with source data and the "chart I've made with Excel" to which "I want to add data bands".
    Let us know if you have any questions.
    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
    11-13-2020
    Location
    Reykjavík, Iceland
    MS-Off Ver
    Excel 365
    Posts
    6

    Re: Charts with Data Bands

    I don't think I have Excel 2016 anymore (my profile was wrong, sorry about that). I have Excel 365 which is administrated by the company I work for. I now have Version 2111 (Build 16.0.14701.20206) if that helps anyone.

    However, I did not get this to work. Switching to layout 5 did not create these bands I'm looking for.
    I'm not able to attach a file to this reply. I'll try to add it to a separate reply.

    Thank you.

  4. #4
    Registered User
    Join Date
    11-13-2020
    Location
    Reykjavík, Iceland
    MS-Off Ver
    Excel 365
    Posts
    6

    Re: Charts with Data Bands

    I'm only able to attach a file with the "insert image" button. Hope it works but if not here is a picture of similar data.

    2022-02-01_21-53-42.png

    Excel_Data_bands.xlsx

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

    Re: Charts with Data Bands

    Can't set it up the way it is shown in post #1, however perhaps this will be of some help.
    1. Station column moved to far right.
    2. Line chart with data points.
    3. Material, Flow [l/s], Temp [°C] and Station [m] columns all chosen for Category Axis
    Let us know if you have any questions.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    11-13-2020
    Location
    Reykjavík, Iceland
    MS-Off Ver
    Excel 365
    Posts
    6

    Re: Charts with Data Bands

    This might work if I set the "Stations" up to be even.
    Thank you.

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

    Re: Charts with Data Bands

    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. Tax Bands
    By alive555 in forum Excel General
    Replies: 7
    Last Post: 02-02-2019, 10:08 AM
  2. [SOLVED] Modifying table formula to extract data by price bands
    By chilli76 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 11-10-2016, 06:29 AM
  3. [SOLVED] Bands for weekends
    By James__S in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-14-2015, 08:26 AM
  4. Replies: 2
    Last Post: 09-15-2015, 04:12 AM
  5. Probability Bands
    By clattenburg cake in forum Excel General
    Replies: 1
    Last Post: 08-13-2013, 05:57 AM
  6. How many bands or artists can you see....
    By ratcat in forum The Water Cooler
    Replies: 20
    Last Post: 02-22-2009, 06:42 AM
  7. [SOLVED] Quartiles and bands
    By microsoft in forum Excel General
    Replies: 1
    Last Post: 05-05-2005, 11:06 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