Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

Percentages in Excel Graphs

Hello, I'am trying to enter a formula to get the percent of each bar on the graph to appear at the top of the bar. I just want it to state what percent it is on top. I used the formula wizard to set it up. I thought it did it automatically, but can't find that option. Help!


Post your answer or comment

comments powered by Disqus
This is probably a very simple issue, but I don't know how to word the search.

I have two issues with an excel graph to automate it.

My first problem is that I have to manually select the source data when the data changes inside my spreadsheet. I have 35 slots that represent a 5 week period. Because the first day of the month does not always start on the first day of the week, I have to allow the extra 5 slots in my template. I have the cells set to show blank when there is no data entered in certain cells. Therefore, only days that the machine is up gets put into the 35 cell table. When I do this, the blank cells show up as 0 on the graph and it skews the line. I need some solution that will allow me to tell the graph to ignore zeros.

The second issue is the title in my graph. I have a set title, but need it to pull "Month Year" and "c81" from the worksheet it is on. I cannot seem to get it to populate automatically in the label. I would like it to look like the following:

614 Machine Uptime Percentage
%Month Year%
MTD PCT (%c81%)

where the %name% is the automatically populated item. I don't necessarily have a problem with hiding a cell and linking the label to that cell inside the graph, but I need it to change those two items automatically.

Im certain that a resolution to both of these items exist and I am certain it is an easy thing that I will be kicking myself in the rear over once I find out the resolution, but I need to get this done and im tired of wasting time. I hope this makes sense. If you need me to post an excel file as an example, I will be more than happy to. Your help will be greatly appreciated.

Hey I am new member. I have problem in labelling data points in a scatterred graph in excel. I have three columns-A,B and C. I want to do a scatter plot between Column A and B. But the label to be dispalyed for those points in the graph I would like to be the value of Column C. I have large dataset, so it is really hard for me to label it manually for each data point. So I would like to know an automated procedure where I can label all the dat points at once. Currenlty the excel allows to label for either values of X axis or Y axis. So I would highly obliged if any one can help me out.

Thanks
Indrajit.

I have the following data:

X Axis - Years (2004, 2005 ,...)
Y Axis - Quantity (imported, exported, produaced)
Z- Axiz - Name of the products

I want to make a graph with teh X, y,z axis in excel. When i use the 3D graphs in excel, it is not taking the z vales connected to teh cell. Anybody can help me pllllllll

I have several columns of data with percentage values and I'm trying to use
some of the new, default conditional formatting options in Excel 2007 -
specifically the little pie chart icons. The formatting doesn't seem to be
applying correctly when I use percentages in the cells. It's as if the system
isn't even looking at the value in the cell and just choosing the first icon
in the list. I'm seeing similar problems using just about any of the default
formats against percentage values. Is anybody else seeing this kind of
weirdness?

I'm trying to fill the area between 2 line graphs in excel. I need to
present the two lines in different colors, plus i need to add another line in
between the two lines. I tried using the "area" option in excel and while it
shaded the area between the line graphs, it did not allow me to add the extra
line in between.

Hi

I am having problems with percentages in Excel 2003. When I key in any decimal values, for example, 0.05 and format this cell to percentage style, the cell shows 5% but so does the Formula Bar. Previously the Formula Bar would have continued to show 0.05. My problem is that I then want to import these percentages in Access and I am getting import errors possible because of the % symbols being seen as text.

Any suggestions or comments would be much appreciated.

Shirley Munro

ok, so ive probably been working on this equation for way too long, this is what i need help with, an equation in excel that will give me a portfolio percentage, i've came up with this:

Portfolio % = Current Value of the Stock / Total Current Value of All Stock held in Portfolio Current Value = Last Price * Number of Shares

these are the numbers i have: 13.49/91041.80= whateve that # is *45. that answer is .006519..... the answer needs to be .67 (%). what am i doing wrong?? any help would help...thanks

In excel graphs - bar charts, I make the last bar a hashed shading as it is a
forcast. To do this I select only the last bar and change its formating. At
the end of the month I want to change the format back to the same as all the
other bars and make the new coming month's predicted value that hashed
shading etc.

Unfortunately excel will not allow copy and paste in this situation - so I
have do open the format tab etc and then change.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.charting

I am using an interactive excel grqph to display series information (user
form) whenever a data series point is selected. Color and size of the
selected point temporairily change for visual reference. The auto-updating in
excel graph results in screen redrawing with each selection. I am looking for
a VBA method to control this updating behavior and suppress multiple
redrawing activity. --
ewt

Hi,
I have never been able to get the full title show up in excel on the y axes.
It always truncated is when I align it at 90 degrees. For example, I am
trying to name the axes US $ Millions and this gets truncated at US $ Mill.
Does anyone know how this can be fixed.

Solution very much appreciated.

In excel graphs - bar charts, I make the last bar a hashed shading as it is a
forcast. To do this I select only the last bar and change its formating. At
the end of the month I want to change the format back to the same as all the
other bars and make the new coming month's predicted value that hashed
shading etc.

Unfortunately excel will not allow copy and paste in this situation - so I
have do open the format tab etc and then change.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.charting

I'm generally quite happy with how excel graphs the moderately
non-linear x-y data I supply it - the curves pass through all the data
points with a pleasing fit.

I'd just like to be able to get excel to interpolate on the graph for
me. For instance, the curve passes through the points (x1, y1) and
(x2, y2) which I supplied. How do I get excel to calculate and supply
the value y3 from the point (x3, y3) on the curve it generated when I
specify the value of x3?

I need a vertical line in my graph to show that the graph information after
the line is the future predicted outcomes. I've tried countless different
options and cant seem to find how to do this!

I'm trying to insert a line with a Y-intercept of zero and a slope of negative -1 into an Excel graph. This is not a trend line or average so it is mathematically independent from any data set. Thanks for the help.

Hi

I have a graph with a line. The line itself is a downward curve sloping line.

If I recreate the values from this chart, I am wondering is possible in Excel to derive the formula from this line?

Thanks for the help!

S

I am trying to plot a graph by given points, may anyone tell me how to construct the best fit line in excel? Also, the points on my x-axis are all like 3.1, 3.4, 3.9 etc, and when I tried to plot the graph, the x-axis started from 3.3, not 0, also, I cannot make the scale go evenly, like one space for 0.1 etc. May anyone please help on this? Thanks a lot in advance.

Hi

I have been asked whether I can design a bar graph where the bars change colour depending on the value. (Whilst I am fairly confident in my ability with Excel, I am only new at using VB, so my apologies in advance.)

Basically, I need the following:

if the x value falls within range a (approximately the first 30% of the y axis) then the bar should be red
if the x value falls within range b (approximately the middle 40% of the y axis)then the bar should be green
if the x value falls within range c (approximately the top 30% of the y axis)then the bar should be purple

I haven't done a lot of experimenting with graphs in excel, but as far as i know there is no easy way to do this, so i wondered if anyone here would know if/how i can do this using VB.

Thanks

Megs

What are the Default {RGB} colors for graphs in Excel 2011?

I don't want an approximation. I want to match what is has used in some of the automatically generated graphs elsewhere.

Need help with graphing in Excel 2007.
I have the following data:
Product Price Elastic Coefficient
$5 3.000
4 1.400
3 0.714
2 0.333
1 1.000

I need the horizontal line (product price) on a line graph to run from $1 to $5 and keep the corresponding data (elastic coefficient) in its appropriate row – since the elastic coefficient is a computed vale, I cannot simple sort on the price column as that will destroy the correct coefficient.
How can I, without typing a special column for price, get the horizontal line to run from $1 to $5.

Has anybody got any recommendations for creating chromaticity graphs in Excel? I'm looking for a simple, configurable way to create them in Excel, using either the built-in tools or a plug-in. I don't mind buying one as long as it is resonably priced. Here's the sort of thing I'm looking to create: http://en.wikipedia.org/wiki/Image:CIExy1931_sRGB.svg

This would be for a mixed Excel 2004/2008 environment, all running under MacOS X 10.4/10.5.

Can you recommend a way to graph the function f(x) = (x-y)^2 in Excel. Is creating random data points the way to go?

Thanks

Is it possible? I want to have my left axis be stock price (data ranges from $15 to $70), my right y-axis be EPS (data ranges from -$1.40 to $3.00), and my X-axis obviously dates, for the last five years. I'd ideally like them to both be line graphs. However, I don't even see the combination bar/line graph available in Excel 2003. Any help is appreciated.

Hi there,

I have a PPT deck with roughly 60 slides that needs updating once a month. Each slide has a single enhanced metafile picture copied from an Excel deck, where worksheet 1 is the content for slide 1 of the deck. I can't embed the graphs because the file size is too big. So my question: Is there a way (a macro, a linking technique) to have these pasted graphs updated in Powerpoint automatically when a change is made in Excel? This would save me a ton of time each month!

Thanks,
Dino

Hi!
I am using Excel 2007 together with the operating system: Windows XP
My problem affects the most basic feature of Excel, graphing. I am trying to create a graph with values for the x-axis being 0-85, together with three series. After my data has been input I select it by draging a box over it and then I press Scatter graph or any other graph for that matter. This results in a x-axis going up to 1.2 and y-axis going up to 1. It also give the graph the title of 85 and series 1 the same name, which is strange as 85 is meant to be the ending value of y.
When I select the graph in order to see from where it takes the data, I can see a green box covering A17-C17, then a blue box covering D17. A third purple box covers the rest of D(1-16).
It is very hard to describe the problem I am facing, but I would be very grateful for anyone who knows how to fix it, I have used Excel 2007 on another computer and then there is only a blue and green box, so if anyone knows how to remove the purple box it would be great. thx


No luck finding an answer? You could always try Google.