Showing posts with label CHARTS Excel. Show all posts
Showing posts with label CHARTS Excel. Show all posts

Formatting Charts,Plot,Axis, Legend, Gridlines,Data Series Area

 When you are satisfied with your chart, you can customize the chart by formatting the following:
1-Chart Area                        5- Axis                   
2- Chart Title                       6- Legend 
3- Plot Area                         7- Gridlines
4- Axis                                8- Data Series

Chart Toolbar, Selecting, Changing, Adding, Removing , Moving , Resizing , Deleting Data

First / Using the Chart Toolbar
 »  Displaying the Chart Toolbar/The Chart toolbar provides quick access to commonly  used actions. Each action is represented by an icon. When you put your mouse pointer over an icon, it is highlighted in blue and a descriptive tool tip appears.
From the main menu, choose View     Toolbars  → Chart.

►Creating and Modify Chart in Microsoft Excel

CreatingChartsare visually appealing and make it easy for users to see comparisons, patterns, and trends in data. For instance, rather than having to analyze several columns of worksheet numbers, you can see at a glance whether sales are falling or rising over quarterly periods, or how the actual sales compare to the projected sales. The following is an example of a column chart:You can graphically present your data with Excel’s charting features.