ICT Tutorials
  • HOME
  • INTRO & WINDOWS
    • INTRODUCTION >
      • FUNDAMENTAL OF IT
      • TYPE OF COMPUTER DEVICES
      • COMPUTER GENERATION
      • SYSTEM COMPUTER
      • TYPE OF COMPUTERS
      • NUMBERING SYSTEM
      • TYPE OF MOUSE
      • KEYBOARD
      • DATA PROCESSING
      • OPERATING SYSTEM
      • HISTORY OF COMPUTER
    • MS WINDOWS >
      • ABOUT MS WINDOWS
      • WINDOWS DESKTOP
      • Win Control Activation
  • MS OFFICE
    • ABOUT MS-OFFICE
    • MS WORD >
      • INTRO TO MS-WORD
      • FILE >
        • INFO, NEW, OPEN
        • SAVE AND SAVE AS, PRINT
        • SHARE, EXPORT, CLOSE
      • HOME >
        • CUT, COPY, PASTE, FORMAT PAI
        • FONT
        • STYLES
        • FIND, GO TO, REPLACE
      • INSERT >
        • PAGES -COVER, BLANK, BREAK
        • TABLES
        • ILLUSTRATIONS >
          • PICTURES, ONLINE PICTURE
          • SHAPES, ICONS, 3D MODELS
          • SmartArt
          • CHART, SCREENSHOT
        • LINK, BOOKMARK, CROSS-REF
        • COMMENT, HEADER/FOOTER
        • TEXTS >
          • TEXT BOX, WORDART, DROP CAP, OBJECT
        • SYMBOL
      • DRAW >
        • PENS
      • DESIGN >
        • DOC STYLES, WATERMARK
        • PHARAGRAPH
        • PAGE COLOR, BORDERS
      • LAYOUT >
        • PAGE SETUP, SPACING
        • ARRANGE OBJECTS
      • REFERENCES >
        • TABLE OF CONTENTS
      • MAILINGS >
        • ENVELOPES
      • REVIEW >
        • DOC REVIEWS
      • VIEW >
        • WEB LAYOUT, NEW WIN, SPLIT
        • SWITCH WINDOWS, MACROS
    • MS EXCEL >
      • INTRO TO MS-EXCEL
      • FILE >
        • INFO, NEW, OPEN
        • SAVE/SAVE AS, PRINT
        • SHARE, EXPORT
      • HOME >
        • ALIGNMENT >
          • CELL ALIGN, ORIENTATION
          • INDENTS, MERGE & CENTER
        • NUMBER, COND FORMAT
        • TABLE, INSERT, DELETE
        • FORMAT >
          • ROW HEIGHT, COLUMN WIDTH
          • HIDE, RENAME, MOVE OR COPY
        • PROTECT SHEET, FILL
        • SORT & FILTER, AUTOSUM
      • FORMULAS >
        • INTRO TO FORMULAS
        • MATH & TRIM >
          • ABS( ), COMBIN( )
          • SUM FUNCTIONS( )
          • COS( ), SIN( )
          • BASE( )
        • STATISTICAL >
          • AVERAGE FUNCTIONS( )
          • MAX FUNCTIONS( )
          • MIN FUNCTIONS( )
          • COUNT FUNCTIONS( )
          • MODE FUNCTIONS( )
        • ENGINEERING >
          • BIN2DEC
          • CONVERT
        • TEXT FUNCTIONS >
          • LEFT( ) RIGHT( ) MID( )
          • FIND( ) LEN( ) PROPER( )
          • TRIM( ) EXACT( ) FIXED( )
          • REPLACE, UNICHAR, UNICODE
          • CODE( ) CHAR( ) REPT( )
        • DATE & TIME FUNCTIONS >
          • TODAY( ) YEAR( ) DAYS( )
        • LOGICAL >
          • IF( ), IFERROR( )
          • IFS( ), SWITCH( )
          • AND( ), OR( )
          • IFNA( ), XOR( )
      • INSERT >
        • CHARTS, SPARKLINES
      • PAGE LAYOUT >
        • PRINT TITLES, SHEET OPTION
      • DATA >
        • GET DATA, DATA VALIDATION
        • CONSOLIDATE
      • VIEW >
        • WORKBOOK VIEWS
      • Excel Functions Exercises >
        • Exercises 1 and 2
        • Exercises 3 and 4
    • MS POWER POINT >
      • INTRO TO MS-POWERPOINT
      • FILE >
        • INFO, NEW, OPEN
        • SAVE AND SAVE AS, PRINT
        • SHARE, EXPORT, CLOSE
      • HOME >
        • NEW SLIDE, STYLES, FILL
      • INSERT >
        • PHOTO ALBUM, VIDEO, AUDIO
        • SCREEN REC, SHOT, SLIDE NUM
      • DESIGN >
        • THEMES, SLIDESIZE, FORMAT
      • TRANSITION >
        • TRANSITION, SOUND
    • MS ACCESS >
      • INTRO TO MS-ACCESS
      • FILE >
        • HOME, NEW, OPEN
    • OFFICE QUESTION & ANSWER
  • VISUAL STUDIO
    • VISUAL BASIC .NET >
      • INTRODUCTION
      • .NET FRAMEWORK
      • OPERATORS IN VB.NET
      • DATAYPES IN VB.NET
      • VB.NET KEYWORDS
      • VARIABLE AND CONST
      • INTRO TO VB.NET PLATFORM
      • INTRO TO PROGRAMMING
      • OBJECTS USAGE IN WIN-FORM
    • Python >
      • Introduction
    • C++
  • GOOGLE TIPS
    • GMAIL ACCOUNT >
      • Email Forwarding
      • Setting up Authenticator App
      • SIGNATURE SET UP
    • GOOGLE WORKSPACE
  • INVENTS
    • NEW INVENTS
  • ABOUT ME

CHARTS, SPARKLINES

21/12/2017

0 Comments

 
Chart:
Let me explain about the Chart in MS-Excel 2016:
In this section we’re going to start to look at what many people consider to be one of the greatest strengths of Excel and that is the ability to create really good Graphs and Charts.
 
So, why do people use Graphs and Charts in Excel? Well usually it’s to strengthen a message or sometimes to actually give the message itself. As the saying goes, a picture can paint a thousand words. And very often, particularly with complex data a picture can help people to understand the data without getting too baffled by all of the numbers.
 
Now I should warn you that the area of Graphs and Charts in Excel is a pretty vast area so we’re going to start with the basics as usual and I’m going to use some very straightforward data here about bonus sheet for a company calling Bright Level. And what I’m going to do first of all is to create a straightforward Graph or Chart to illustrate the staff names and their bonus amount.
 
Let me give the name of Chart styles are provided in MS-Excel and all the charts are using for different purposes because of different needs;
1. Column
2. Line
3. Pie
4. Bar
5. Area
6. X,Y (Scatter)
7. Map
8. Stock
9. Surface
10. Radar
11. Treemap
12. Sunburst
13. Histogram
14. Box & Whisker
15. Waterfall
16. Funnel
17. Combo

How to create a column chart to only the fields calling Name and Total Annual from the Bright Level – Bonus Sheet 2017, that’s already entered data table in the workbook?
Select both fields “Name & Total Annual” =>
Select Insert Tab =>
Click Column Chart Tool =>
Click a style that you like.

For more understanding, look at the screenshot please:

Picture

Sparklines:
Sparklines are tiny charts inside single worksheet cells that can be used to visually represent and show a trend in your data. There three types of style sparklines are available like lines, columns and win/loss to create a mini chart.
 
Sparklines can draw attention to important items such as seasonal changes or economic cycles and highlight the maximum and minimum values in a different color. Showing trends in your worksheet data can be useful, especially when you’re sharing your data with other people.
 
Because a sparkline is embedded in a cell, any text you enter in the cell uses the sparkline as its background, as shown in the following example. If you select one cell, you can always copy a sparkline to other cells in a column or row later by dragging or using Fill Down (Ctrl+D).
 
How to create a sparklines mini chart using column style?
Select a column of data that you want to create sparklines mini chart =>
Select Insert Tab =>
Click Column Tool=>
Select the location that you want to view mini chart (if you need to view the chart on top of the data, select same column or different column).
 
For more understanding, look at the screenshot please:

Picture
if you have any questions about tools in insert menu, please state all in the comment box
0 Comments

    Archives

    December 2017

    RSS Feed

​WELCOME TO WWW.COMTEACHERS.COM and We Would Love To Have You Visit Next Time Too! FOR MOBILE USERS, TO READ THE NOTES PLEASE CLICK MENU ICON, IT SHOULD BE EITHER ON TOP LEFT OR RIGHT CORNER OF YOUR SCREEN AND THEN CLICK MENU BY MENU TO CONTINUE READINGS...
  • HOME
  • INTRO & WINDOWS
    • INTRODUCTION >
      • FUNDAMENTAL OF IT
      • TYPE OF COMPUTER DEVICES
      • COMPUTER GENERATION
      • SYSTEM COMPUTER
      • TYPE OF COMPUTERS
      • NUMBERING SYSTEM
      • TYPE OF MOUSE
      • KEYBOARD
      • DATA PROCESSING
      • OPERATING SYSTEM
      • HISTORY OF COMPUTER
    • MS WINDOWS >
      • ABOUT MS WINDOWS
      • WINDOWS DESKTOP
      • Win Control Activation
  • MS OFFICE
    • ABOUT MS-OFFICE
    • MS WORD >
      • INTRO TO MS-WORD
      • FILE >
        • INFO, NEW, OPEN
        • SAVE AND SAVE AS, PRINT
        • SHARE, EXPORT, CLOSE
      • HOME >
        • CUT, COPY, PASTE, FORMAT PAI
        • FONT
        • STYLES
        • FIND, GO TO, REPLACE
      • INSERT >
        • PAGES -COVER, BLANK, BREAK
        • TABLES
        • ILLUSTRATIONS >
          • PICTURES, ONLINE PICTURE
          • SHAPES, ICONS, 3D MODELS
          • SmartArt
          • CHART, SCREENSHOT
        • LINK, BOOKMARK, CROSS-REF
        • COMMENT, HEADER/FOOTER
        • TEXTS >
          • TEXT BOX, WORDART, DROP CAP, OBJECT
        • SYMBOL
      • DRAW >
        • PENS
      • DESIGN >
        • DOC STYLES, WATERMARK
        • PHARAGRAPH
        • PAGE COLOR, BORDERS
      • LAYOUT >
        • PAGE SETUP, SPACING
        • ARRANGE OBJECTS
      • REFERENCES >
        • TABLE OF CONTENTS
      • MAILINGS >
        • ENVELOPES
      • REVIEW >
        • DOC REVIEWS
      • VIEW >
        • WEB LAYOUT, NEW WIN, SPLIT
        • SWITCH WINDOWS, MACROS
    • MS EXCEL >
      • INTRO TO MS-EXCEL
      • FILE >
        • INFO, NEW, OPEN
        • SAVE/SAVE AS, PRINT
        • SHARE, EXPORT
      • HOME >
        • ALIGNMENT >
          • CELL ALIGN, ORIENTATION
          • INDENTS, MERGE & CENTER
        • NUMBER, COND FORMAT
        • TABLE, INSERT, DELETE
        • FORMAT >
          • ROW HEIGHT, COLUMN WIDTH
          • HIDE, RENAME, MOVE OR COPY
        • PROTECT SHEET, FILL
        • SORT & FILTER, AUTOSUM
      • FORMULAS >
        • INTRO TO FORMULAS
        • MATH & TRIM >
          • ABS( ), COMBIN( )
          • SUM FUNCTIONS( )
          • COS( ), SIN( )
          • BASE( )
        • STATISTICAL >
          • AVERAGE FUNCTIONS( )
          • MAX FUNCTIONS( )
          • MIN FUNCTIONS( )
          • COUNT FUNCTIONS( )
          • MODE FUNCTIONS( )
        • ENGINEERING >
          • BIN2DEC
          • CONVERT
        • TEXT FUNCTIONS >
          • LEFT( ) RIGHT( ) MID( )
          • FIND( ) LEN( ) PROPER( )
          • TRIM( ) EXACT( ) FIXED( )
          • REPLACE, UNICHAR, UNICODE
          • CODE( ) CHAR( ) REPT( )
        • DATE & TIME FUNCTIONS >
          • TODAY( ) YEAR( ) DAYS( )
        • LOGICAL >
          • IF( ), IFERROR( )
          • IFS( ), SWITCH( )
          • AND( ), OR( )
          • IFNA( ), XOR( )
      • INSERT >
        • CHARTS, SPARKLINES
      • PAGE LAYOUT >
        • PRINT TITLES, SHEET OPTION
      • DATA >
        • GET DATA, DATA VALIDATION
        • CONSOLIDATE
      • VIEW >
        • WORKBOOK VIEWS
      • Excel Functions Exercises >
        • Exercises 1 and 2
        • Exercises 3 and 4
    • MS POWER POINT >
      • INTRO TO MS-POWERPOINT
      • FILE >
        • INFO, NEW, OPEN
        • SAVE AND SAVE AS, PRINT
        • SHARE, EXPORT, CLOSE
      • HOME >
        • NEW SLIDE, STYLES, FILL
      • INSERT >
        • PHOTO ALBUM, VIDEO, AUDIO
        • SCREEN REC, SHOT, SLIDE NUM
      • DESIGN >
        • THEMES, SLIDESIZE, FORMAT
      • TRANSITION >
        • TRANSITION, SOUND
    • MS ACCESS >
      • INTRO TO MS-ACCESS
      • FILE >
        • HOME, NEW, OPEN
    • OFFICE QUESTION & ANSWER
  • VISUAL STUDIO
    • VISUAL BASIC .NET >
      • INTRODUCTION
      • .NET FRAMEWORK
      • OPERATORS IN VB.NET
      • DATAYPES IN VB.NET
      • VB.NET KEYWORDS
      • VARIABLE AND CONST
      • INTRO TO VB.NET PLATFORM
      • INTRO TO PROGRAMMING
      • OBJECTS USAGE IN WIN-FORM
    • Python >
      • Introduction
    • C++
  • GOOGLE TIPS
    • GMAIL ACCOUNT >
      • Email Forwarding
      • Setting up Authenticator App
      • SIGNATURE SET UP
    • GOOGLE WORKSPACE
  • INVENTS
    • NEW INVENTS
  • ABOUT ME