The document contains sales data for books and MP3s across various months, along with cumulative totals. It also includes budget allocations for different departments and sales figures by country. Additionally, it outlines instructions for creating various charts in Excel, including clustered column, line, pie, and funnel charts.
The document contains sales data for books and MP3s across various months, along with cumulative totals. It also includes budget allocations for different departments and sales figures by country. Additionally, it outlines instructions for creating various charts in Excel, including clustered column, line, pie, and funnel charts.
The document contains sales data for books and MP3s across various months, along with cumulative totals. It also includes budget allocations for different departments and sales figures by country. Additionally, it outlines instructions for creating various charts in Excel, including clustered column, line, pie, and funnel charts.
The document contains sales data for books and MP3s across various months, along with cumulative totals. It also includes budget allocations for different departments and sales figures by country. Additionally, it outlines instructions for creating various charts in Excel, including clustered column, line, pie, and funnel charts.
Download as XLSX, PDF, TXT or read online from Scribd
Download as xlsx, pdf, or txt
You are on page 1/ 13
Sales BOOKS MP3's Cum
Jan $600 $825 825
Feb $700 $950 1775 Mar $750 $750 2525 Apr $500 $925 3450 May $775 $875 4325 June $625 $800 5125 July $800 $975 6100 Aug $915 $750 6850 Sept $855 $775 7625 Oct $600 $825 8450 Nov $575 $700 9150 Dec $675 $775 9925
Month Sales Jan $300 Feb $175 Mar $200 Apr $175 May $225 June $250 July $100 Aug $150 Sept $300 Oct $225 Nov $250 Dec $275
DEPARTMENT BUDGET Human Resources $1,000 IT Staff $750 Customer Service $2,250 Administration $800 Marketing $1,500
Country Sales India 43000000 USA 44000000 Germany 45404440 Russia 43000200 France 43555344 North Usa 43555344 Create chart, add secondary axis & name, Save the chart as template. delete the add lables, change chart name chart & insert again using template
Select cells Select Chart
A2:D14>Insert>Clustered column Right click chart Save as template Delete the chart Select Chart> Tab Chart Design>Change Chart Type>Select Select cells Combo chart type A2:D14>Insert>Recommended Select series Cum>Chart Type Charts>All Charts>Templates Line>Tick mark on secondary axis Select recently created template
Create line chart
Create pie chart
Create map chart, change color of INDIA as template. delete the Copy the chart & paste in PPT or Word again using template document as paste option "Link Data". Edit in excel & see the changes in PPT/Word also
rt>Recommended arts>Templates ly created template State/Union Territory Population #,##0,K #,##0.0,,,"B" #,##0.0,,"M" Andhra Pradesh 55.4M 55,435K 0.055B Arunachal Pradesh 1.6M 1,571K 0.002B This chart isn't available in your version of Excel. Assam 35.4M 35,407K 0.035B Editing this shape or saving this workbook into a different f Bihar 125.4M 125,426K 0.125B break the chart. Chhattisgarh 29.5M 29,542K 0.030B Goa 1.6M 1,586K 0.002B Gujarat 63.6M 63,565K 0.064B Haryana 28.5M 28,505K 0.029B Himachal Pradesh 7.5M 7,452K 0.007B Jammu and Kashmir 13.5M 13,535K 0.014B Jharkhand 38.5M 38,547K 0.039B Karnataka 65.9M 65,855K 0.066B Kerala 35.5M 35,466K 0.035B Ladakh 0.3M 274K 0.000B Madhya Pradesh 85.5M 85,465K 0.085B Maharashtra 128.5M 128,547K 0.129B Manipur 3.0M 3,015K 0.003B Meghalaya 3.4M 3,355K 0.003B Mizoram 1.3M 1,255K 0.001B Nagaland 2.1M 2,055K 0.002B Odisha 45.5M 45,465K 0.045B Puducherry 1.5M 1,455K 0.001B Punjab 30.5M 30,547K 0.031B Rajasthan 81.5M 81,547K 0.082B Sikkim 0.6M 619K 0.001B Tamil Nadu 75.5M 75,465K 0.075B Telangana 35.5M 35,465K 0.035B Tripura 4.1M 4,055K 0.004B Uttar Pradesh 245.5M 245,465K 0.245B Uttarakhand 11.5M 11,547K 0.012B West Bengal 95.5M 95,465K 0.095B version of Excel.
workbook into a different file format will permanently
Month Sales Jan 30 Select Cells A1:B13 & Feb 17.5 Mar 20 Sales Apr 17.5 May 22.5 May Copy any icon & p June 25 Apr July 10 Aug 15 Mar Select any bar, Form Sept 30 Oct 22.5 Feb Nov 25 Jan Dec 27.5 Select cells B2:B13>C 0 5 10 15 20 25 30 35 or create ;; to hide
or create ;; to hide numbers from table & chart New Visual - Funnel
Stage of Marketing Leads Remaining This chart isn't available in your version of Excel. Cold Call 120 Editing this shape or saving this workbook into a different file format w Meeting 70 permanently break the chart. Interested 60 Converted 20 xcel.
