Results 1 to 2 of 2

Thread: Creating and formatting Sparklines

  1. #1

    Creating and formatting Sparklines

    Register for a FREE account, and/
    or Log in to avoid these ads!

    Found these questions confusing.Can someone provide an answer?

    1. On the JanFeb worksheet, insert a row below the times, and then summarize the data for each day of January by using a Column Sparkline in that row. Apply the Sparkline Style Colourful #4 style, and then accentuate the First Point and Last Point data markers

    2. Copy the formatted Sparkline from January to February

    3 1. On the MarApr worksheet, insert a column to the right of the dates, and then summarize the data for each hour by using a Line Sparkline in that Column. Apply the Sparkline Style Accent 6, Darker 25%, and then display all the data markers without placing emphasis on any specific type of data marker.

    4 Copy the formatted Sparkline from March to April and ensure that it appears only for the days of the month

    The working files and the question from its source is attached below
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	img001 (1).jpg 
Views:	24 
Size:	85.3 KB 
ID:	3029  
    Attached Files Attached Files

  2. #2
    Conjurer Roger Govier's Avatar
    Join Date
    Mar 2011
    Located near Abergavenny, South Wales, UK

    Select Row 4 > right click > Insert which will create a blank row
    Select C4:O4 > Insert tab > Sparklines > Columns > in the dialogue box that appears, select your data range (C5:O35) > OK
    The row of sparklines will appear in row 4 and the Design tab will show all the options for Colour, Style etc.
    Click the dropdown at the right of the Style section, and you can then choose the request Style.

    Hopefully, from this, you will be able to understand the rest of the instructions and also do the same type of thing for Column.

    Your result should look something like the fle attached.
    Attached Files Attached Files

    Roger Govier
    Microsoft Excel MVP

Tags for this Thread

Posting Permissions

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