Informatics Module 3 Notes

Creating and formatting charts

Creating and formatting charts in Excel means turning raw spreadsheet numbers into a visual picture and then styling that picture so it is easy to read and understand.


• Visualizing Data: It converts plain tables of data into shapes, bars, lines, or slices.

• Spotting Patterns: It helps you quickly see trends, high points, low points, and comparisons that are hard to find in a list of numbers.

• Better Communication: It makes reports and presentations easy for others to understand at a glance.


Types of Excel Charts

• Column / Bar Charts: Best for comparing different items or values side-by-side.

• Line Charts: Best for showing changes or trends over time.

• Pie Charts: Best for showing parts or percentages of a whole.

• Scatter / Combo Charts: Best for showing relationships between numbers or mixing two chart styles.

STEPS ( CHART CREATION)

1. Select  data: 
Highlight the cells containing the data you want to display, including the table headers and category labels.

2. Go to the Insert tab:

 Click the Insert tab at the top of the Excel ribbon.

3. Choose a chart type:

 • Click Recommended Charts to let Excel suggest a good layout for your specific data.

 • Or

 click one of the specific chart icons (such as Column, Line, Bar, or Pie) in the Charts group.

4. Insert the chart: 

Click your preferred chart option, and it will immediately appear on your worksheet.


FORMATING CHARTS IN EXCEL

To format a chart in Excel, select  chart and use the quick-access buttons on the top-right corner, or navigate to the Chart Design and Format tabs on the ribbon.

1. Add and Adjust Chart Elements

• Click the + (Chart Elements) button next to the top-right corner of your chart.
• Check or uncheck items like Chart Title, Axis Titles, Data Labels, Legend, or Gridlines.
• Right-click any specific element (such as an axis or data label) and choose Format [Element Name] to open a detailed customization pane on the right side of your screen.

2. Change Colors and Styles

• Click the Paintbrush (Chart Styles) icon next to the chart to quickly switch color palettes and preset designs.
• Alternatively, go to the Chart Design tab on the top ribbon to choose from pre-made styles or click Change Chart Type if you need a different layout.
• To color individual bars or data points, click a data series once to select all bars, or double-click a single bar, then use Shape Fill under the Format tab.

3. Customize Axes and Numbers

• Right-click the horizontal (X) or vertical (Y) axis and select Format Axis.
• Expand the Number section to change currency, percentage, or decimal formats.
• Adjust Bounds (minimum and maximum values) or Units (intervals) under Axis Options to control how  data scales.

4. Copy Chart Formatting

• If  already styled one chart and want to apply the same look to a new one, select your formatted chart and press Ctrl + C.
• Select the target chart, go to the Home tab, click the drop-down under Paste, and choose Paste Special > Paste Formats.


GRAPHICAL REPRESENTATION OF DATA

A graphical representation of data in Excel means turning raw numbers and tables into visual charts or graphs. This makes complex data easier to read, analyze, and share.

Purpose

1• Visual Clarity: Transforms dense rows and columns of numbers into pictures.

2• Trend Identification: Highlights patterns, growth, and drops over time.


3• Quick Comparisons: Makes it simple to compare values, proportions, and rankings across categories.


4• Better Decision-Making: Helps business users and analysts interpret info at a glance

PIVOT TABLE AND PIVOT CHART 

An Excel Pivot Table is a tool that organizes, summarizes, and analyzes large datasets, while an Excel Pivot Chart is a visual representation that links directly to that summary.










Comments

Post a Comment

Popular posts from this blog

ASSIGNMENT : MARKETING MIX

🔽MARKETING MIX The term "Marketing mix" was introduced by Prof. Neil H. Borden of the Harvard Business School. Marketing mix is one of the most fundamental concepts in marketing Management. These are: product, pricing, distributive channels (place) and sales promotion techniques. 🔽Definition of Marketing Mix: According to Philip Kotler, "Marketing mix the mixture of controllable marketing variables that the firm uses to pursue the sought level of sales in the target market." 📍Marketing Mix is a set of elements that need to be determined by a company to promote its brand or product effectively. Often called 4 Ps of marketing. (product,price,place, & promotion) 1.PRODUCT   The product in a marketing mix refers to the tangible good, intangible service, or digital offering that a business provides to satisfy customer needs and wants. A product is a commodity, produced or built to satisfy the need of an individual or a group. The product can be intangible or tang...
Read more

6th sem tally assignment

Image
COMPUTERISED ACCOUNTING Computerized accounting is  the use of accounting software to record, store, and process financial transactions electronically, replacing manual methods like ledgers . This system automates tasks like invoicing and payroll, leading to increased accuracy, efficiency, and faster reporting. 🔽ADVANTAGES 🔽 1.Speed and efficiency:  Tasks like data entry, calculations, and report generation are much faster, saving significant time compared to manual methods.  2.Accuracy:  Automation reduces human error from manual calculations and data entry, leading to more reliable financial records.  3.Real-time data:  Financial information is updated immediately, providing up-to-date insights for better and more timely decision-making.  4.Automated reporting:  Generating financial statements like profit and loss accounts and balance sheets becomes an instant process.  5.Reduced paperwork and storage:  Storing records el...
Read more

tally notes

Image
🔽Bank reconciliation🔽 Bank reconciliation explains the difference between the bank balance shown in an organization's bank statement and the corresponding amount shown in the organization's accounting records, on a particular date. To reconcile the bank statement Go to 'Gateway of Tally > Banking > Bank Reconciliation' Select the name of the required bank The 'Bank Reconciliation' screen appears: Match every transaction with the bank statement and record the transaction date in the 'Bank Date' field. Accept the screen to reconcile the bank ledgers as per the corresponding banking statement. 🔽TRAIL BALANCE 🔽PROFIT AND LOSS ACCOUNT BALANCE SHEET 🔽COST CATEGORY IN TALLY
Read more