Question about Computers & Internet

1 Answer

Unable to create chart in excel

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.

Posted by on

  • Anonymous Mar 16, 2009



    when i try to create the chart in excell2007 the chart option not enable pls help me 

    Vijay Khator

×

Ad

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that has over 10 points.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 16 Answers

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

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE:

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

Excel Error Message.What can I do to stop this error?


A corrupt excel spreadsheet can be repaired by using Open and Repair technique. It is a built-in repair function that opens a corrupt excel file forcefully.
*OpenMS Excel >pressCtrl+O >locate corrupt excel spreadsheet and select it.
*Click on the arrow shown besideOpenbutton>selectOpen and Repair.
It will take just a few seconds to be completed and selected file will be opened, if possible.

Or if this doesn't work, one may take help of a third-party

For example Excel Fix Toolbox
https://www.fixtoolbox.com/excelfix.html

Apr 24, 2015 | Microsoft Office Excel 2007

Tip

Excel - Drop Down List Ever wish that you didn't have to type...





Excel - Drop Down List

Ever wish that you didn't have to type out the same thing over and over again? Well you can save time by using Excel's drop down list!


Drop Down Preparation

Imagine that we are creating an Excel spreadsheet to document our purchases from the grocery store. For each purchase we want to mark down the name of the food and the type of the food.
The way a drop down list works in Excel is that it takes values from some place on your spreadsheet and uses them to populate the options in the list. Lucky for us, the type of food is a perfect opportunity to use a drop down list!
In cells A1 through A7 enter the type of food that will be used for the drop down list.


Creating a Drop Down List

Now that we have a source for our drop down list, we can create a begin to create our drop down.
1. Select cells D2 though D20 (We will be creating a drown down list for each cell in this range)

2. Click the Data menu and select Validation
3. Choose List from the Allow drop down menu

4. Click the Source button that appears to the right of the textfield

5. Select our source cells A1 though A7

6. Press Enter and Click OK

Testing Your Drop Down

All of your cells in the Type column should now have a drop down list. To test to see if your drop down works, click on cell D2 and then click on the downward facing arrow and see if all the types of food are available.

on Nov 19, 2013 | Microsoft Excel Computers & Internet

3 Answers

Create an organogram


This is easy if you have an office that you wish to create the organogram for and you have Visio or Excel to make this.
BIG BOSS
Assistant boss1 Assistant boss 2
Supervisor1 Supervsor 2
Enginer1 Enginer2 Pilot 1
Enginer3 Enginer4 Pilot 2
etc. etc.



Aug 31, 2014 | Clothing

1 Answer

About microsoft excel


Made by Microsoft, used for creating, opening and managing spreadsheet data files created with the application. Spreadsheets allow you to manipulate numbers, formulas, information and extrapolate resulting information, graphs, charts, organized lists, export data to create all sorts of useful results.
Not sure what else you want to know...

Aug 22, 2012 | Facebook Computers & Internet

3 Answers

What is excel


Hi,

Microsoft Excel is a commercial spreadsheet application . It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.
Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display.

Regards,
Shrey

Jun 04, 2011 | Microsoft Excel for PC

2 Answers

How to make a 7 row and a 7 coloum in a spreadsheet


Creating a table in Microsoft Excel 2007 allows you to work with that data independently of the rest of the worksheet. First you must define your table, though, which you can do either from scratch or from data already in the worksheet. The process is a simple one. Read on to learn how to define a table in Excel 2007
  • 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.

  • Thanks for choosing Fixya............ Sandeep

    Mar 18, 2011 | Computers & Internet

    1 Answer

    How to make tally charts on my laptop?


    To create a tally chart in a laptop,the laptop must a spreadsheet package like Microsoft excel

    these are the steps involve
    -select the data to be use for graph.include the column and row label in sections
    -select data
    -click on number tab
    -click on text
    -click ok
    -click on chart wizard icon on the tool bar
    or
    click on insert on menu bar
    click on standard tab or custom types tab
    under chart type list ,click to select the desire chart type eg tally.
    under chart sub -type list,click to select the chart desire.
    click on next button.
    click on data range tab under series to select rows or columns.
    click on next button.
    that solve it.I hope you"ll find the solution post useful,dont forget to leave your comment by saying hope hopeful this post is to you

    Oct 07, 2010 | Computers & Internet

    4 Answers

    Solution for Excel 2003 "the file is not in a recognizable format"


    If you open an excel created by M/S Office 2007, Excel 2003 will not be able the file. You have to install Microsoft Office the "Compatibility Pack for Word, Excel, and PowerPoint File Formats" for M/S Office 2003 from Microsoft Site.

    or

    Your Excel file is corrupt!

    Hope it helps.


    Oct 01, 2010 | Computers & Internet

    1 Answer

    Does the Graph/Chart option exist for Mac Excel?


    Yes, it does.

    Choose the data in which you want to graph by highlighting said data, including and row/column headings. Then click the icon, which looks like a graph, in the top toolbar which will open up the Chart and Graph Wizard. Then follow the steps and guidelines to create your chart or graph.

    Hope this helps. Have a great evening!

    Feb 17, 2009 | Microsoft EXCEL 2004 for Mac

    1 Answer

    Average handle time


    I have created a spreadsheet for you to a) use and b) to learn from.

    It is an Automated spreadsheet (as they should be) which calculates the number of minutes in a working week or month and calculates the average time per email giving Daily, Weekly and Monthly Outputs. It takes into account Public Holidays (or for time off). You can use the Output to create Graphs etc to visually display the Output.

    It also allows you to calculate a Part Month average.

    I have displayed it as it was CONSTRUCTED and as it would be USED.

    The As Used worksheet is Protected and the only Inputs that can be done are in the Green Boxes (also the Saturday and Sunday boxes but you will need to Unhide the Validation List to include these and then to add 2 more columns titled Is Saturday? and Is Sunday? with the appropriate If Statement.

    To unprotect the sheet go to Tools - Protection - Unprotect. There is no password so leave this blank.

    All the workings are still there, the columns are just Hidden. To Unhide them, highlight the columns to the left and right of the hidden columns, click on Format - Columns - Unhide. To hide them again, highlight the columns that you want hidden, click on Format - Columns - Hide.

    The LOGIC used (as in Functions) may seem complex but if you read the Descriptions in the first row you should be able to work out what and why it was done that way. Click on a cell to see what Function was used where.

    You said that your spreadsheet was becoming a real mess, well I have created a monster for you (but not a mess).

    I have uploaded the file to here:

    http://users.tpg.com.au/lesliecl/

    Hope this gives you the push to really start using Excel.

    Apr 04, 2008 | Microsoft Excel for PC

    Not finding what you are looking for?
    Computers & Internet Logo

    Related Topics:

    728 people viewed this question

    Ask a Question

    Usually answered in minutes!

    Top Computers & Internet Experts

    Les Dickinson
    Les Dickinson

    Level 3 Expert

    18429 Answers

    Alun Cox

    Level 3 Expert

    2679 Answers

    Brad Brown

    Level 3 Expert

    18067 Answers

    Are you a Computer and Internet Expert? Answer questions, earn points and help others

    Answer questions

    Manuals & User Guides

    Loading...