Question about Computers & Internet
I have filled the columns in the spreadsheet. when i click the chart icon on the toolbar , a chart is created, this is unicolor, with grid lines.. not as a column chart should be.it also cant create a pie chart or any chart. pie chart appears as a single vertical line. i use ms xp home edition with office 2003.
Check the source data that it is using to create your chart (right-click choose SOURCE DATA). The result you're getting sounds as if it may not include all the data you want to chart. Generally should include at least two rows AND at least two columns.
Posted on Nov 18, 2007
Tips for a great answer:
Apr 24, 2015 | Microsoft Office Excel 2007
on Nov 19, 2013 | Microsoft Excel Computers & Internet
Aug 31, 2014 | Clothing
Aug 22, 2012 | Facebook Computers & Internet
Jun 04, 2011 | Microsoft Excel for PC
Start off by doing one of the following: Select the range of cells that you want to make into a table within your worksheet then proceed to Step 2 OR Start immediately with Step 2.
Click on the "Insert" tab at the top of the document.
Find the "Tables" group, then click on "Table." The "Create Table" dialog box will appear.
Type in a range for your table if you did not select a range in Step 1. If you did already select a range then that range will automatically appear in the dialog box.
Check the "My Table Has Headers" box if the data set you selected already contains the headers you want to use. If you don't check this box, the table will display default header names, which you can then go in and change.
Hit the "OK" button at the bottom of the Create Table dialog box to create your table.
Mar 18, 2011 | Computers & Internet
Oct 07, 2010 | Computers & Internet
Oct 01, 2010 | Computers & Internet
Feb 17, 2009 | Microsoft EXCEL 2004 for Mac
Apr 04, 2008 | Microsoft Excel for PC
May 22, 2020 | Power Computers & Internet
740 people viewed this question
Usually answered in minutes!