I need to make a chart on Microsoft Excel using Office Supply info for two months?
betoni asked:
So as a project for a course I need to make a chart using the Office supply info for two month January and February. I have already entered all the info into Excel using the types of supplies, Cost/unit, Number of Units, total cost, and % of Grand Total for both months. In the course book it shows what the chart is suppose to look like but every time I do it it tends to look nothing like it should. I can’t seem to figure it out at all. It is suppose to be a 3D clustered Column Graph with the x axis at a - 45 degree angle and also on the x axis are the different office supplies and on the y axis are numbered 0.00 - 120.00 .Does anyone understand or know what I need to do in order to get the correct information??
This entry was posted
on Sunday, February 1st, 2009 at 12:00 am and is filed under Software.
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.
So as a project for a course I need to make a chart using the Office supply info for two month January and February. I have already entered all the info into Excel using the types of supplies, Cost/unit, Number of Units, total cost, and % of Grand Total for both months. In the course book it shows what the chart is suppose to look like but every time I do it it tends to look nothing like it should. I can’t seem to figure it out at all. It is suppose to be a 3D clustered Column Graph with the x axis at a - 45 degree angle and also on the x axis are the different office supplies and on the y axis are numbered 0.00 - 120.00 .Does anyone understand or know what I need to do in order to get the correct information??
February 3rd, 2009 at 7:49 pm
Since I can’t see your course book, I’m assuming you want to make a 3D cluster chart of total cost for January and February for each type of supply.
Select the range of cells that have the total cost of each item for January. The first Cell should be the column Label something like “January Total Cost”.
-Select Insert\Chart
-Select 3D Column Chart and Finish
-Right Click on the chart and select Source Data
-Select the Series tab
-In the “Category X-axis Labels” text box, put the range of cells that have the Types of Supplies listed.
-Click the “Add” series button
-In the “Values” text box, select the range of cells that have the February total cost data.
-In the “Name” text box, select the cell that has the February Total Cost column label
-OK
-Right-click on any of the X-axis labels on the chart
-Select Format Axis
-Select the Alignment tab
-Adjust the orientation of the text to 45 degrees
-OK
If you need to set the Y-axis scale to 0.00 to 120.00
-Make sure all your cells with total cost is formatted with two decimals. To do that,
–select your total cost cells and then right-click on them.
–Select Format Cells.
–Select the Numbers tab
–Select Currency or Number and two decimal places.
–Do this for both the January and February Total Cost cells.
-If the Y-Axis doesn’t have the range set to 0 to 120…
–Right-click on any number on the Y-axis.
–Select Format axis.
–Select the Scale tab.
–You can set the minimum and maximum values for the Y-axis.
Like I said before, I’m making a lot of assumptions on what you want but I hope this gets you pointed in the right direction.