How to Make a Pie Chart in Microsoft Excel?

How to make a pie chart in Microsoft Excel?

MS Office software is consisting of many applications like MS Word, MS Excel, MS PowerPoint and MS Access etc. Every application makes the work of the organization easier and faster. This software can be easily installed through www.office.com/setup. Here we discuss about how to create a Pie chart in MS Excel using Excel Chart Wizard.

Short Guide of creating Pie Chart in MS Excel:

Here you will understand how to create a pie chart in MS Excel but if you do not understand properly then go to the site office.com/setup .

    1. Enter the Pie Chart Data: It does not matter what type of chart you want to create. First you have to create the Excel chart and then enter the data into the worksheet.
    2. Select the pie chart data:  First of all with the mouse, highlight the cells which contain the data which you want to include into the graph. Now use the keyboard, you have to click on the top left of the graph data. After this, hold down the shift key. Now use the arrow keys, to select the data which is to be included in the pie chart. 
    3. Start the Chart Wizard: For starting the Excel Chart Wizard, you have to click on the Chart Wizard icon on the standard toolbar. Now click Insert and then Chart in the menu.

    4. The Excel Chart Wizard: First you have to choose the Pie Chart Type in the left hand pane. Then choose the Pie with a 3 D visual effect chart. After this click on Next. 
    5. Preview your Chart:  First of all select your data, before starting the Excel chart wizard. Then on your Spreadsheet, the data has been included in the chart and it is surrounded by the marching ants. There is a animated black border around your data. Below the preview window, there is a box containing the cell references of the data range. Make sure you select the right data range in the spreadsheet. 
    6. Customize your Chart: For customizing your chart, click on the Titles tab which is at the top of the chart wizard dialog box. Now in chart title box, you have to type the title. After this click on the data labels tab which is at the top of the chart wizard dialog box. Now in the label contains section click on the percentage option. If the chart in the preview window looks right then click on Next. 
    7. Choose where your chart should go: Here you click on the radio button to place the chart as an object in Sheet 1 and click on finish. Your pie chart is created. 
    8. Add color to the Pie chart: Change the background color of the chart. For this, right click with the mouse anywhere on the white background to open the drop down menu. Now click on the Format Chart Area to open the Format Chart Area dialog box. Then click on the pattern tab, to select the color. At last click on OK.

If you have any kind of problem in creating the Pie Chart then you can visit to the official website of www.office.com/setup. Or you can contact to the customer care for Microsoft Office account and assistance.

What are the alternatives to MS Office in 2020?

What are the MS in 2020?

MS Office is the software which is developed by Microsoft and it is the most productive suite for creating text documents, presentations and spreadsheets. This software can be easily installed through www.office.com/setup. And great technical assistance is given by the MS Office team to their users. It is reliable for Windows, Mac, OS and also for Android Phones. Till now there is no comparison to this software but people still search for the alternatives. So, the IT industry, generally introduces the range of alternatives to MS Office in 2020. We here are discussing some of the alternatives along with their strength and weaknesses.

Best Microsoft Office Alternatives:

  1. Free Office:
    This is a free and easy alternative to MS Office. This suite can be used in homes and in the workplace. This suite is developed for Linux and Windows. It is compatible with MS Word, MS Excel, and MS PowerPoint. Its interface is similar to MS Office and it has touch screen compatibility. But it is not used for Mac OS version.
  2. Libre Office:
    This is a free and easy alternative to MS Office. This suite can be used in homes and in the workplace. This suite is developed for Linux and Windows. It is compatible with MS Word, MS Excel, and MS PowerPoint. Its interface is similar to MS Office and it has touch screen compatibility. But it is not used for Mac OS version. 
  3. WPS Office:
    This is the excellent free tier and advanced feature for its users. It supports Windows, Linux, IoS, and Android Users. It is available in multi-languages like English, French, German, Spanese, Portugese, Polish and Russian. It is being criticized because all fonts are not automatically included and they have to be installed separately, Interfaces is quite slow at times and for Android users installation is quite large. 
  4. iWork:
    This is an excellent, free and easy to use office suite. It includes pages, keynotes, and numbers. You can create beautiful presentations without any hassle. It is being criticized because you cannot open documents and it is available for Mac only. 
  5. Calligra:
    This is free and open source software. It has some extra features like mind mapping and project management tool. This software is criticized because you can only read document but you cannot edit them. There are some other compatibility issues also.
  6. Office Suite:
    This suite has some extra editing tool for those who are willing to pay for them. In this only one license is needed for all devices and allows synchronizing among devices. It has several tiers but the basic tier is free. It has been criticized because it pressurized users for purchase premium subscription.You can download through MS Office via Office.com/setup.
  7. Apache Open Office:
    This is developed by Apache. It is free, easy to use and reliable productive suite. It is famous for its consistent performance. It is not for the advanced users. It has a very few designs as compared to PowerPoint.

So, In spite of all these alternatives, till now there is no such software made which can fully compete with MS Office software. You can download easily through Www.office.com/ setup and gives superb technical assistance.

 

You can also know about – How to manage Your Office My Account?

How to resolve Window 10 error code 1935?

How to resolve Window 10 error code 1935?

MS Office is the software which was developed by Microsoft and it has many applications which increase the productivity of the organization. It is very easy to install via Www.office.com/setup. This error occurs when try to run or install certain application, games and programs and occurs on all Window versions. You can fix this issue by following this method.

Methods to fix Error Code 1935:

Solution 1: Check your Antivirus:

The basic reason for the error code 1935 is that the antivirus installed in your device prevents you to run or install any applications. If this the reason then disable the antivirus installed in your device. If disable does not work then you have to remove the antivirus installed in your device. If these fix the issue then install another secure antivirus in your device.

Solution 2: Use Command Prompt:

To fix this issue use command prompt press the Windows Key + X to open Win + X menu then choose Command Prompt (Admin) or Power Shell (Admin) from the list of options. After this type the command: fsutil resource set auto reset true C:. Now C: drive is the place where Window 10 is installed, but if you install this on other drive then change the drive letter. At the end restart the computer system.

Solution 3: Modify your Registry:

Sometimes it is necessary to make changes in the registry, and this helps in fixing the issue 1935. To make changes, press Windows Key + R and enter regedit. Now, click on Enter or click OK. After this in the Window Registry Editor,  Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control After this in the Registry Editor dialog box, double click on RegistrySizeLimit> the Edit DWORD Value dialog box will appear on the screen. In that dialogue box, you have to enter the ffffffff as the Hexadecimal value > and now click on Decimal radio button > and enter the digit 4294967295 as the decimal value. At the end click on Ok> reboot the machine.

Solution 4: Run the application in Compatibility Mode:

This is the feature which optimizes the older applications for Window 10 and you can use this mode for the new applications also. For this you have to locate the problematic applications and right click it and select Properties from the options. After this, go to compatibility Tab and tick on Run this program in compatibility mode for. After this select the version of Windows, and click on Apply and Ok to save the changes. By following this issue will be completely resolved.

Solution 5: Install the missing updates:

Check the updates by following this method; first of all open the Setting App by pressing the Window +I , when the setting app opens then go to the update and security section. After this, click on Update button. After updating check the error is resolved or not.

Conclusion:

If this fix the issue 1935 then it’s ok, otherwise contact to the Technical team of MS Office through office.com/setup. They are experienced and can solve your problem in minutes and available for you all the time.

How to create a floor plan by using Microsoft Visio?

How to create a floor plan by using MS Visio?

MS Office is the great and popular software which increase the productivity of every organization and make their work easier and faster. This software can be installed by just visiting to the official website office.com/setup. It has many applications like Skype, Outlook and MS Visio etc. Every application has its own functions. Here we are discussing about MS Visio and its benefits.

What is MS Visio?

MS Visio is a diagram tool and it helps to create flowcharts, diagrams, create maps and floor plans. It has variety of build in shapes, objects, and stencils which makes your work easier. In this you can also create your own shapes. This application is very helpful for the architectures, builders and home designers.

How to create a floor plan by using MS Visio?

In the MS Visio option, use the Floor Plan template to create the floor plans for the individual room or for the entire floor of the building. This will include the wall structure, building core and other electrical symbols.

Start a new Floor plan:

For creating a floor, in the category list, click on Maps and Floor Plans category. Then click on Floor Plan and then click on create.

Create the Exterior Wall Structure:

Using room shapes, from the wall, shell and structure stencil drag one room shape to the drawing page. Resize the room shape by using the resizing tool.

Using the wall shapes, from the structure stencil drag the exterior wall structure to the drawing page. You can resize the walls by dragging an endpoint, to set the options right click wall shapes, and drag the endpoint from wall to another.

Create the Interior Wall Structure:

From the structure stencil, drag the wall shapes to the drawing page and position them inside the exterior structure. Again resize the walls, right click on to set it and drag the endpoint from one wall to another.

Add doors and windows:

From the wall, structure and shell stencil, on the top of the wall drag the wall and window settings.

Add Structural Elements:

For structural elements, from the structure stencil drag the structural shapes such as columns to the drawing page. From the building core stencil, drag the shapes such as stairs on to the drawing page.

Add Electrical Symbols and Dimension lines:

From the electrical and telecom stencil, drag the switches, and other wall fixtures onto the drawing page. Then right click on wall, and add dimensions. And reposition the dimension lines.

Insert a CAD floor plan:

In the insert tab, and in the illustration group, click on CAD drawing.  And in the Insert Auto CAD drawing, select the CAD file you want and click on Open. Accept the size and location and click ok.

Save as DWG file:

On the file tab, select Save As >Browse. Now change the Save as type to Auto CAD drawing (.dwg).

Conclusion:

If you have any kind of issue then you can contact to the customer care of MS Office via www.office.com/setup. They will help you in every way at any time and at any place.