+ Reply to Thread
Results 1 to 6 of 6

Visulise levels as a graph or sparklines

  1. #1
    Forum Contributor
    Join Date
    09-06-2011
    Location
    manchester england
    MS-Off Ver
    Office 365
    Posts
    283

    Visulise levels as a graph or sparklines

    I have a set of plot levels that I would like to see visually on a graph / sparkline..
    I have enclosed a sample row, so this is a house plot and there could be up to 200 of these, I would like to see a visualisation at the end of the row of figures

    Is this possible it doesn't matter if it is small, just want to see the up and downs of the levels.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,612

    Re: Visulise levels as a graph or sparklines

    Graph and sparklines attached.
    Attached Files Attached Files
    Ben Van Johnson

  3. #3
    Forum Contributor
    Join Date
    09-06-2011
    Location
    manchester england
    MS-Off Ver
    Office 365
    Posts
    283

    Re: Visulise levels as a graph or sparklines

    Thanks Ben,

    Could I ask a couple more questions please?

    I have uploaded a revised version based on yours.

    1. Can the spark lines be split over the headings in separate columns, so i Can see what is going up or down and what heading it relates to? So one column for each heading?
    2. I have moved the relevant graph to a new tab, is this then easy to copy for eah row/plot number, as i ill have over 200 on some sites?

    Thanks for the help.
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,612

    Re: Visulise levels as a graph or sparklines

    1. Since a sparkline is a mini-graph in one cell, it's not possible to split the data points into separate cells or "stretch" it over several cells. In your 2nd attachment, I put a sparkline for each column vs. each row.
    2. Each chart will have to be created separately...
    3. You can custom format column A of Plot Output sheet as: "Plot: " # and enter only the number in the cell without the text string. Then, when you create your charts, just use the column A cell for the series name:
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    09-06-2011
    Location
    manchester england
    MS-Off Ver
    Office 365
    Posts
    283

    Re: Visulise levels as a graph or sparklines

    Thank you for your help, I just away at the moment and will have a proper look tomorrow.

  6. #6
    Forum Contributor
    Join Date
    09-06-2011
    Location
    manchester england
    MS-Off Ver
    Office 365
    Posts
    283

    Re: Visulise levels as a graph or sparklines

    Thanks for this it is what I was looking for.

+ 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. [SOLVED] Nested levels of 61 giving error as over 64 levels
    By RJK in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 05-14-2020, 01:07 PM
  2. Dynamically set graph axis min/max levels
    By ivibr8 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-18-2020, 10:30 AM
  3. Help with Sparklines
    By sovietchild in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 02-17-2018, 04:14 AM
  4. [SOLVED] Dynamic Sparklines
    By Salvucio in forum Excel General
    Replies: 8
    Last Post: 01-14-2015, 10:15 AM
  5. Sparklines on a graph for KPI's
    By dsciola in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-09-2014, 04:35 PM
  6. Sparklines in Excel
    By sgriggins3 in forum Excel General
    Replies: 1
    Last Post: 06-12-2012, 05:46 PM
  7. Line graph:water tank levels
    By gwmbox in forum Excel General
    Replies: 3
    Last Post: 01-05-2011, 12:27 PM

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