sponsored ads

how to make 2d column chart

sponsored ads

 hi guys.

i am not familiar with the 2d column chart making in excel. but i need to do that because of my work.can you give me some guide on this?ths~

Asked Nov, 22 2010
add commentflag 

sponsored ads

answer this question

1 answers

 In Microsoft Excel, you can create a variety of chart types. and there are many tutorial in the internet :lwww.ehow.com/how_6513582_create-combination-chart-ms-excel.html

Answered Nov, 22 2010
add comment|flag 
vote up 0 vote down

1.Open up Microsoft Excel 2007 on your computer.
2.Enter the desired category data for the information you want to compare in the A column. Each category should be in a cell beginning with A2. In the example below, I used Fuel, Clothing, and Entertainment costs.

3.Highlight the data in the spreadsheet by clicking on the upper left hand corner of the data table, then drag the mouse across the entire data range.

4.Click on the “Insert” Tab in the menu at the top of the screen. This will be the second tab from the left
5.Select the type of chart that is best suited for the display you want. When you put your mouse over the chart option, you'll see a description of what the chart display is good for. For example, select “2D Bar” in a clustered column for the type of chart. The chart will appear on the spreadsheet using the data in a 2D form.
6.Click on your graph and and then click on the layout tab. To add graph titles or axis titles simply click on the titles tab. A drop-down menu will appear where you can choose the one you prefer.

7.Make changes to the chart as needed in the title, legend, fonts, etc. by clicking on the text and editing it.
Answered Jan, 15 2011
vote up 1 vote down

1. : Select the data that you want to include in your pie chart.
2. From the Insert tab on Excel’s ribbon, click on the down arrow under Pie in the Charts section. This will expand the Pie Chart menu.
3. Select the first choice in the 2-D Pie category.
read more :www.brighthub.com/computing/windows-platform/articles/15345.aspx Answered Mar, 25 2011
vote up 1 vote down

1.In the report is designed to create a new report that uses the information below :

Data source
------------------
Name: Northwind
Type: Microsoft SQL Server
Connection string: data source=<Instance of SQL Server>;initial catalog=Northwind

Query string
------------------
SELECT TOP 10 *, NULL AS NullUnits
FROM [Alphabetical list of products]
WHERE (UnitsOnOrder > 0)

Report name
------------------
TrendReport
2.In layout view add the diagram control.
3.Pane in the field, select the fields,Then drag the field data to the  fields of the trendchart control to : Inventory or Order.
4.Pane in the field, select the fields,then drag the category field, parts of the trendchart control to :
Category id or Product name.
5. On Trendchart chart control,With the right mouse button click,And then click properties.
6.In the properties dialog box click the data tab
7.In the values list and click unit order, and then click edit
8.Graphics value in a dialog box click the tab
9.Click to select the drawing data as a line of the check box, and then click determine
10.In the properties dialog box click to determine
 
 
 
 


 
 
 




 
Answered Nov, 07 2010
vote up 0 vote down

Your Answer

community wiki:

The Verified Code is to stop spamming. It will be hidden once your reputation reached 100.
or
Create one

Options

sponsored ads

Download related software from AFC

K-Chart 1.0

Last Updated: Sep 2, 2011
License:
Filesize: 22KB

Continue to downloadPower by Afreecodec.com