ANmarS - Search results

Excel/VBA expert since Sep 1997 (21 years 2 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

25 Q & A posts tagged with graph

Thu
Nov 17
2011

Thinner bars than default settings in excel?

I have selected the thinnest bar available in Excel. Are there ways to download a custom width that is slightly thinner that would be noticeable on a print out? I have to do some graphing and the thinnest bars are still slightly too thick.. I dont want to use dashed lines either


Answer

As far as I understood you
You can modify the width of these bars by going Right click then selecting Format
These options can do that for you

If not, then try to change the type into 3D, then you can modify gaps too

good luck

Thursday 11/17/2011 9:28:23 PM
Thu
Nov 17
2011

Please Help! How would i draw this graph on excel 2010?

http://imgur.com/IMLLE

Sorry the pic isn't rotated, and it's kinda small...
I can't figure out how to graph it:S I don't know how to insert negative x values in the graph, and i don't know how to change the default x values of 1,2,3,4, etc. to different numbers...
Please help! best answer will get 10 points today cause i'm in a ruuuush!
Thanks!


Answer

This one looks like a SIN(x) graph for me
just do 1, 2, 3, 4, etc in col A, then do
=Sin(A1)
in column B

Then graph it

hope this is not too late

Thursday 11/17/2011 4:27:33 AM
Wed
Nov 16
2011

How do you graph data on Excel using two Y axes?

I have the values for the data on the left side of the graph but I want them on the right side. When I right the axis there isn't any 'properties' but Format Axis instead. I'm using Excel 2010 by the way.. Any idea on how to get the Y axis to the right side?


Answer

You need to do like this

http://folder8.com/View/?W0V

Wednesday 11/16/2011 5:07:56 AM
Mon
Nov 14
2011

How to make a double line graph on Excel?

I have the temperature of the days of the week high and low how do I put that into a double bar graph?


Answer

I have a file that does that, have it here
http://Folder8.com/F/?Yan

file called "High_Low_Temperature Chart.xls"

let me know if that helped

Monday 11/14/2011 3:59:55 AM
Mon
May 17
2010

How do you change the what order lines go on a graph in excel?

I have an excel graph and i want to move one line in front of the other. How do I do that?


Answer

In Excel 2007
- Select the chart
- Go to Design tab > Select Data > then select the series you want to move and click on the up and down arrow in that window to move it up or down

In Excel2003
- Select the Chart
- Go to Chart > Source Data
- In Series tab, move it up and down as required

If you are talking about the 3D chart you have, then that can be made the same way since Excel is using that order to draw the lines

VBAXLMan

Monday 5/17/2010 7:59:50 AM
Fri
May 7
2010

How can I insert intervals of numbers, not discreet elements into Excel?

I need to sketch the sin, cos functions' graph in Excel. I have a problem with a domain. I don't want to manually type myriad values - even then, the graph is sharp, not curved, and inaccurate. Is there a possibility that I simply set an interval, infinite, but bounded set, as a domain? If yes, how do you do it?


Answer

You need as many points as you can to do the exact curved sin
to answer your question, do the following:
- Do the first number you want in a cell, say you do 5 in cell E4
- Now do the second number with the intervals into the second say.
So if you want to have the numbers as 5, 15, 25 (with 10 interval), put 15 in cell E5
- Now select both cells
- Drag the selection from the black square at the right bottom corner down to whatever range you want.

Or, you can also do:
- Put 5 in cell E4
- Select some range of cells including cell E4 (Cells E4 to E20)
- Go to:
Edit > Series > Fill (if you have Excel2003 or earlier)
Home > Fill > Series (below SUM sign)

And select the interval and stop value

VBAXLMan

Friday 5/7/2010 1:54:43 PM
Thu
May 6
2010

How do you label extra information on Excel line graphs?

So if I already made a line graph and then the instructions say that I need to label the point at which certain things happened in time along the line, how do I do that on Excel. (without doing it by hand)

Thanks :)


Answer

What do you mean, "by hand" ?

You can do the following:
Show labels for all data points
Select the point you want to label
Click on it again (not double click), just click on it again after few seconds
Now you can modify that point's label

VBAXLMan

Thursday 5/6/2010 5:16:55 PM
Tue
May 4
2010

How would I create the type of graph shown in the link below?

I have data in excel for the daily minimum and maximum temperatures and daily rainfall for a full year.


Also, what is the name of this style of graph?


Answer

Use the regular column chart
It is called Histogram, but Excel will not recognize that name, use Column chart
Assuming you have the data listed by date.

VBAXLMan

Tuesday 5/4/2010 4:02:44 AM
Fri
Apr 30
2010

How do you put two different lines on a graph in excel?

Thanks.
I need a baseline and intervention line.


Answer

In Excel, to control a graph, you need to design its table
So it is all about tables here

New line means new series, so you need to add another series to do that

I used to add another series, having same value for all data points, and add it to the graph series

VBAXLMan

Friday 4/30/2010 5:59:00 PM
Thu
Apr 15
2010

How to determine an unknown X value on excel?

So we had to do a beer's law plot in my chemistry class. I have an unknown sample's absorbance and I need to determine the concentration. We are suppose to use excel to do so. The absorbance is my Y value and the concentration is graphed on the X axis. How can I determine the concentration of my sample. Thanks for helping me!


Answer

You should have either a formula that runs the graph
Or a graph so we can get the formula
You cannot do it other way
If you have a formula, you can easily apply to get X value using it

If you have a graph, then you need to add trendline (Right click on that curve and select "Add Trendline")
Doing so will show you a window that enables you to show the formula
from that formula you can get the X value

Let me know if you did or not, I can guide you through that process if you lost

VBAXLMan

Thursday 4/15/2010 8:08:20 AM
Sun
Apr 11
2010

How do I make a half life graph on excel?

Excel keeps making it into a weird kind of graph, and I want a line graph with the years as the X axis and % left as the Y axis


Answer

Once you have the values in two columns
Insert chart, make sure you select the XY-Scatter from the chart type

VBAXLMan

Sunday 4/11/2010 4:40:21 PM
Thu
Apr 8
2010

How do i add 2 different sets of data to one graph on Excel 2007?

im doing a chemistry lab and i have to make a computer generated graph with excel. im using Microsoft Excel 2007 and im having trouble. ive added my info and for some reason it wont let me put the 2 different sets of data on the same graph. my two axis' are supposed to be temperature on the Y-axis and time on the X-axis. ALSO: if it is possible for you guys to help me find out how to do the "best fit line technique" i would really appreciate it.


Answer

To add new series
- Select your chart
- Go to Design tab
- Click on "Select Data"
- Click "Add"
- Select the new series values/title, etc

That is all

Now regarding "Best fit line"
- Right click on the series you want to add best line to it (The line you want to get its best fit)
- Select "Add Trendline"

Hope this is what you are asking about

VBAXLMan

Thursday 4/8/2010 5:15:25 PM
Sat
Apr 25
2009

How do you develop a Trend Equation graph on Microsoft Excel 2007?

I need to develop a trend equation graph for current ratios and other financial ratios, any help would be grateful, thanks


Answer

What do you mean by "Develop"?

Need more info please


VBAXLMan

Saturday 4/25/2009 6:19:14 AM
Sat
Apr 25
2009

How do you develop a Trend Equation graph on Microsoft Excel 2007?

I need to develop a trend equation graph for current ratios and other financial ratios, any help would be grateful, thanks


Answer

What do you mean by "Develop"?

Need more info please


VBAXLMan

Saturday 4/25/2009 6:17:44 AM
Wed
Apr 22
2009

Ms excel help.. .. finding the coefficient of correlation, r^2?

ok so i need help finding the r^2 of linear and nonlinear regressions, to compare which ones fit better......... using excel.

eg. if power reg. curve is 0.998 and quad. curve is 0.992 ... then id choose power reg,

i know how to do it on a graphing calculator... but i need it for an assignment......

so how do i find it for a curve?

p.s. ive got excel 2003.....


Answer

Once you got a graph
- Right click on the line
- Select "Add Trendline"
- Select the type of that trendline
- Go to "Options" tab
- Click on "Show R2 equation"


That is all


VBAXLMan

Wednesday 4/22/2009 6:17:33 PM
Sun
Apr 12
2009

HELP?!?!??! Microsoft excel?

I made a bar graph on Microsoft excel but how do i label the bars (along the X axis) ??

plz help, rlly confusin

thnkx in advance =]


Answer

In Excel2003, do these steps:
1- Select the graph
2- Go to Chart > Chart Options
3- Then go to Chart Titles and change the boxes for x-axis and y-axis labels

In Excle2007, do these
1- Select the graph
2- Two new tabs will be shown after the last one, go to
Layout > Axis title
Then do the Horizontal or Vertical one, based on your needs


VBAXLMan

Sunday 4/12/2009 9:00:33 PM
Tue
Apr 7
2009

Auto Generate Calendar in Excel?

Anyone know how to generate a calendar, in excel, with appointment entries from worksheet data as a sourc?. Just like creating a graph and using worksheet as data source. Want to do the same thing, but populate a calendar. Thanks


Answer

Here is a free calendar for any month any year
It also has the ability to show your appointments for a full year

http://www.file1.net/project.asp?id=k7fr…

Enjoy it

VBAXLMan

Tuesday 4/7/2009 5:43:51 AM
Mon
Apr 6
2009

How to print a chart in Excel 2007?

Help! I have an assignment due tomorrow where I had to make bar graphs in Excel 2007. The graphs are showing up perfectly in print preview, but the actual bars won't print. The X and Y axis and chart title prints only. I have a HP Officejet 6210. I have no idea what to do. Thanks!


Answer

You need to do these steps as they are the most popular reasons for problems like this

1- Clear history and cookies
2- Delete temporary internet files
Both 1 and 2 are in Internet options from Control panel
3- Delete "Temp" folder content (and not the folder), it is in your C: > documents and settings > YOURUSERNAME > Local settings > Temp, this will solve a lot of problems
4- Restart computer and try again

Do Step 3 if you are using WinXP, if you have VISTA, then step 3 would be
3- Delete "Temp" folder content (and not the folder), it is in your C: > Users > YOURUSERNAME > AppData > Temp, this will solve a lot of problems


VBAXLMan

Monday 4/6/2009 4:14:56 PM
Mon
Apr 6
2009

Excel 2007 - Using words in the y-axis?

Hi, I'm trying to make a line chart and coordinating times with letter values where the time is on the X-axis.
i.e.
1200 is ACA
1300 is ACC
1400 is BAD
I need to put the letters/initials into the Y-Axis so instead of charting numbers to numbers, it'll do letters and on the Y-Axis I'll have AAA, AAB, AAC et cetera.
How do I do that? Thank you!


Answer

The Y-axis is where the values are drawn, meaning you can not put letters since letters can not be drawn as line

The Y-Axis has the values that representing the line itself

Does that make sense?

VBAXLMan

Monday 4/6/2009 1:56:36 AM
Wed
Apr 1
2009

How do I draw a normal curve graph on Excel?

For my first set of data, I have a mean of 5.409090909 and a standard deviation of 1.370437585. For the second set, the mean is 4.590909091 and the standard deviation is 1.969289002. How can I draw a normal distribution curve? I have 22 values for each set. Any help would be appreciated.
Regards


Answer

If I understood your question, do this:
Add new series (one for each mean and STDEV) with the same value for all points

And graph it


If this is not what you wanted, let me know

VBAXLMan

Wednesday 4/1/2009 10:39:02 AM
Sat
Jan 17
2009

How do I make a bar graph using Microsoft Excel 2003?


Answer

Type in your data into cells as columns
Then go to
Insert > Chart
Select Bar from the chart type and click finish

This is the fast solution

VBAXLMan

Saturday 1/17/2009 6:29:37 PM
Fri
Jan 16
2009

Getting an equation from points on excel 2007 ?!?

Alright I have a set of data points that I can graph but I don't know how to label the axis or to get it to derive an equation from a line. When I try to type in my AXIS label its says that the formula I tried has an error all I'm trying to do is label AXIS not put in a formula? what do I do?


Answer

When you click on the chart Excel2007 will show you new 3 tabs at the top right
Go to "Layout"
Then click "Axis Titles"

And do your titles here

VBAXLMan is back

Friday 1/16/2009 5:20:08 PM
Fri
Jan 16
2009

I need excel spreadsheet help for my new company?

I'm starting a company based on commission only. I need an equation for excel in which I can input a $$ amount sold and have it auto read the different pay scales and generate their income. in $$s and on a line graph. The pay scale is as follows:

$612 to $1223 is 6%
$1224 to $2447 is 12%
$2448 to $4895 is 24%
$4895 to $ 8499 is 26%
and $8500+ is 27.5%

Thanks!


Answer

Do this pay scale in a separate sheet, make it Sheet1 cells A2:C6 having A2 is 612, B2 1223, C2 6%
and so on
Now, in another sheet, put your amount in cell D4, and in E4 paste this:

=INDEX( Sheet1!C2:C6,MATCH( D4,Sheet1!A2:A6,1))

and this in F4
=D4*E4

That is all

VBAXLMan is back to feed your Excel needs

Friday 1/16/2009 12:14:18 AM
Tue
Dec 5
2006

Hey! is there any Excel expert who can solve this.....? are u here Mr VBAXLMAN..?.?

i would like to create a line chart in ms excel....where "runs" will be ploted in y axis, or vertical axis and "overs" in horizontal axis....
runs will ploted in 50 runs interval and overs will be in 10 overs interval....u might have seen this in cricket...
wait .....it's not so easy one....i've a few conditions
1) the resultant line will be displayed in a single line,,,,i repeat ..in a single line....as u would have noticed in cricket score analysis.
2)it will start from the (0,0) point...that means 0 run at 0 over...
and will travel with the increasing runs and respected overs...(as it is made in graph papers.)
3)i'm using msexcel 2002....so pls solve it in 2002 or older....
i think i've expressed it enough....
if u 've done it then try this for two teams for there score analysis .....obviously there will two seperate line for two teams , say India & Pakistan or Australia & NewZealand...
every good answer will get a thumbs up and the best answer ......u know better


Answer

I got your e-mail.
The solution is all in the table that you will create for it
Wherever hard you think the chart is, the solution is in the table
Excel charts are created from tables, means that you can not (Never) create a chart without its data.
So we are (You and me) have to see how to build the table that will represent the chart

I can't e-mail you through Yahoo, you have not confirmed your e-mail there...
send me your e-mail address, I can not e-mail you

Enjoy my profile, I am the VBAXLMan

Tuesday 12/5/2006 2:10:13 PM
Fri
Mar 31
2006

How do I fix video playback on my computer?

Any time I play video on my computer the image gradually becomes green, regardless of the program I use.


Answer

It seams to me that your SVGA card (Graphic card) problem. Try to reinstall the driver for it, If it still the same I am afraid that your Graphic card is damaged and need to be replaced.

Friday 3/31/2006 11:38:14 AM

Tags

History