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!

- Linking and Ignoring in Excel Graph
- Labelling data points in Excel graph(Plz help)
- XYZ coordinates in Excel graph 3D
- Conditional Formatting not working with percentages in excel 2007
- How to fill the area between two lines in excel graph?
- Percentage problem in Excel 2003
- Portfolio percentage in excel?
- Excel graphs should allow copy & paste of individual bar formats
- Excel graph updating
- Axes titles in excel graphs
- Excel graphs should allow copy &amp; paste of individual bar formats
- Interpolating non-linear curves in excel graphs
- Time line in excel graph
- Inserting a line in excel graphs
- Derive a formula from a Graph in Excel?
- Problems in plotting graphs in excel
- Graphing In Excel
- What are the Default {RGB} colors for graphs in Excel 2011?
- Graph question in Excel 2007
- Chromaticity graphs in Excel?
- Graph a function in Excel
- Two Y-axes in Excel 2007 Line Graph
- Automatic Refresh or Macro to Update Excel Graphs in Powerpoint
- Graphing feature in Excel not working

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.

Thanks

Indrajit.

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

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?

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.

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

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

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

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

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.

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

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?

the line is the future predicted outcomes. I've tried countless different

options and cant seem to find how to do this!

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 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

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

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.

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

Thanks

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

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.