Select your data You can click and drag across the cells where you've entered your data, or you can hold down the shift key while using the arrow keys to select the appropriate cells. Be sure to include all your labels. Select chart. This will open the Chart Wizard. Select the type of chart you want to make Choose the chart type that will best display your data.
For example, pie charts are good for displaying percentages and line charts are good for displaying data over time. If it looks good, click Next. Name your chart Enter a title for your chart where it says Chart Title.
Creating an Excel Chart with both Bars and Lines
This is under the Titles tab. Complete your chart Click the other tabs. You can adjust the way your chart looks by changing the various options listed. The displayed graphic will give you a preview of each change. You can select a chart by clicking it. Sample Pie Chart About Food. Sample Pie Chart About Sports. You'll have to make percentages.
If your data is not in percent, then Excel will create percentages for you. Yes No. Not Helpful 24 Helpful Once you have the pie chart on the board, there are different shades next to it that says "change color"; click on that. Not Helpful 10 Helpful What am I doing wrong if I tried this method and the pie chart didn't show up?
You might have entered information wrongly and it can't process.
Try re-entering your data. Not Helpful 33 Helpful Look for a section that says Chart Elements while the graph is selected. I would recommend tinkering with these options to see what you could use. Not Helpful 2 Helpful 5.
Go to one of the top tabs, and on one it says "charts" then click on it, and it will say Pie Chart. Not Helpful 12 Helpful 7. I would recommend saving the pie chart as an image, navigating to the Insert tab in Excel, and inserting your pie chart as an image. Not Helpful 1 Helpful 2. Select the chart by clicking in the center of it, press Ctrl on your keyboard , and while that key is down, press C. Your chart should show up, but the colors may be different.
Charts + Graphs Training and Tutorials
Not Helpful 0 Helpful 1. Unanswered Questions. How do I combine several common allocations to one total value in a pie chart? Answer this question Flag as Flag as What steps in Excel are used for adding numbers to pie charts?
How do I make my pie chart white only in Excel? Include your email address to get a message when this question is answered. Already answered Not a question Bad question Other.
Tips You can copy your chart and paste it into other Microsoft Office products e. If you want to create charts for multiple sets of data, repeat this process for each set. Once the chart appears, click and drag it away from the center of the Excel document to prevent it from covering up your first chart. Article Summary X 1.
Office 2011 for Mac All-in-One For Dummies
Did this summary help you? Made Recently. Add a photo Upload error. Awesome picture!
Creating an Excel Chart with both Bars and Lines | ningrickicarra.ga ningrickicarra.ga Blog
Tell us more about it? Click here to share your story. Related wikiHows. Article Info This article was co-authored by our trained team of editors and researchers who validated it for accuracy and comprehensiveness.