using a check box to display text from a list
Excel 2003 
 
I am trying to use a check box to display a category (Text) from a list in a 
 
cell and have tried code based on an "if structure" with no success. Has 
 
anyone got any suggestions.
Read Entire Conversation

Ballistics chart
Hello, 
 
I want to make a ballistics chart where I can type in the feet 
 
per second, grains etc. and get all of this info on this site 
 
http://www.beartoothbullets.com/rescources/ so basically I want to 
 
"group" all of those calculations and formulas together for quick and 
 
easy use. 
 
Thanks! 
 
Anthony 
 
-- 
 
sHooTer296
Read Entire Conversation

Lonely Heart
Lady talk 24-Hrs +91 9810577227 
 
OR email to info@lenstar.org
Read Entire Conversation

Help! Messy-looking pie chart!!!
Because a few of my pie chart segments (or is that sectors?!) are very 
 
small percentages, the literals are overwriting each other. I once saw 
 
an example of a pie chart where lines miraculously appeared to 
 
separate the literals out of the way, but I can't find what setting 
 
does all this that. Any ideas? Thanks in advance! 
 
Meriel
Read Entire Conversation

Need to find out if this possible in Excel
I need to take the following information and make a timeline chart in 
 
excel 
 
Date Completed/scheduled 
 
Milestone 1          Date1 
 
Milestone 2          Date2 
 
Milestone 3          Date3 
 
In addition to doing this timeline, I need to find out a way to 
 
automate this process so that if the information is load from another 
 
source into excel that it can be processed automatically into a 
 
timeline chart. 
 
I have many projects and need to find a way to track them with a simple 
 
timeline. 
 
Hope someone can help 
 
-Ron
Read Entire Conversation

rastreadores GPS Ratreador gps localizadores bloqueadores 5425771
CENTRAL ÚNICA DE VENDAS 
 
10 Marcas de ratreadores, Compare e Compre. 
 
Rastreador de Veículo 
 
Rastreadores de Veículos 
 
Rastreador GPS 
 
Rastreadores GPS 
 
Rastreador Ituran 
 
Rastreadores Ituran 
 
Rastreador Portátil 
 
Rastreadores Portáteis. 
 
Assistência 24 Horas 
 
Visite agora mesmo nosso site. 
 
http://tel011-50523122.vila.bol.com.br/ 
 
Graber - Teletrim - Tele Trim - Ituran - 
 
Rastreadores gps , Localizadores, Bloqueadores 
 
Graber - Teletrim - Tele Trim - Ituran - 
 
Ra ...
Read Entire Conversation

How do I create a chart that will show 4 weeks of current info?
I need to be able to create a chart that will update data entered 
 
automatically, in a chart, but is capable of showing many different options 
 
to where the data can come from. I know excel is capable of drop down lists, 
 
but I need to make this application as simple as possible for beginner users. 
 
Any suggestions are welcome, thank-you
Read Entire Conversation

Tiny graph
Each time I create a new graph, it appears micro size. It's difficult and 
 
sometimes not possible to grab the corner to resize. Any ideas?
Read Entire Conversation

graph size
When I create a new graph, it shows up very, very small. How do I get it 
 
sized right? Trying to graph the edge doesn't always work.
Read Entire Conversation

Excel-SAP
who knows how to upload data from Excel sheet to SAP ERP application?
Read Entire Conversation

Subject: Sub/Superscripting should work in Excel Legends/Axis Labe
Well I totally agree with miwilla. Furthermore I would like to add that 
 
obviously this problem hasn't even been solved in Excel 2007. I tried the 
 
beta 2 online and the same problem persists. If there is a workaround I would 
 
kindly like to ask you for an explanation. On the other hand I strongly 
 
recommend that the developers take care of that problem, since it affects 
 
many of us dedicated Excel users. 
 
Keep up the good work! 
 
Cheers 
 
Tobe
Read Entire Conversation

Excel 2002 Zero Values in Charts
Can anyone help please? 
 
I have a column in my woksheet that contains formulae that refers to blank 
 
cells.  Therefore the result is zero in each cell in my column.  When I use 
 
the data in a chart, I set Tools, Options, Chart tab - plot empty cells as 
 
"Not plotted", but it still plots the cells as zero and distorts my chart. 
 
Is there any way to get is to plot the cells that have a formula where the 
 
result is zero, as "not plotted"? 
 
Any help would be appreciated. 
 
-- 
 
Thanks, 
 
Rob E.
Read Entire Conversation

Love Hotline
Lady only 24-Hrs +91 9810577227
Read Entire Conversation

read me first
I an trying to send a spreadsheet to different people, but I want to have a 
 
"READ ME FIRST" page, which has the instructions on it.  When they have read 
 
te instructions a button to click that then allows them to see the rest of 
 
the work book.  I have seen these before, but don't know how to do it
Read Entire Conversation

implemantation of an equation.
Hi, 
 
I am a new user and I need help. 
 
My problem is that have some data(x,y) and I done a chart for them. 
 
However, I need to draw a curve which has this type: y=ax/(1+ax) and 
 
then I draw the erros. I don't know how I can implement this equation. 
 
Could someone help me? It is urgent for me. 
 
In the attachment image you can see what I want exactly. 
 
Thanks. 
 
+-------------------------------------------------------------------+ 
 
|Filename: curve.JPG                              ...
Read Entire Conversation

Ranking Chart
Hello 
 
I have to do a chart from a lot of different dealers. However, I only 
 
want the top 10 dealers to be on the chart and a sum of the rest as 
 
others. Is that possible? 
 
How could I do a tornado style chart? 
 
Thanks for your help 
 
-- 
 
cartera 
 
------------------------------------------------------------------------ 
 
cartera's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=37669 
 
View this thread: http://www.excelforum.com/showthread.php?threadid=572776
Read Entire Conversation

Create and customize axis on all sides of charts
It would be very helpful, especially for large charts, to be able to 
 
define/create an axis for all sides of the chart.  Currently you can only 
 
have a secondary axis if you have multiple data sets in the chart, but it 
 
would be great if you were able to have the chart print the secondary axis 
 
even with a single data set.  If this was possible, it would make sense to 
 
have each axis be independent of the others, allowing for custom scale, 
 
units, formatting, etc. 
 
We have several  ...
Read Entire Conversation

Y-Axis scale from high to low going vertically?
How do you force the Y-axis to start at a high number in a series of data 
 
points, and move lower as you go up the axis?  I have data about performance 
 
(network delay) that has a goal of zero. Actuals are 20, 40, 50 milliseconds 
 
average per month. X-axis is a category-axis with months listed. The average 
 
has been decreasing, and I would like to show this as a line graph slanting 
 
from the lower left to the upper right, as it approaches 0.
Read Entire Conversation

Graphing relationship between 3 variables
I have a data sheet which depends on x, y, and z. Therefore, the 
 
function is something like z = cx + dy, where c and d are constants and 
 
x and y may have exponents. 
 
I don't know, however, how to graph this sort of data in excel. The 
 
surface graph seems really dissatisfactory, and does not offer me the 
 
option of seeing the equation the data makes. 
 
My values are like this: 
 
X--------------Y----------------Z 
 
20-------------0-------------$1,000,232.51 
 
15-------------5------ ...
Read Entire Conversation

Stacked area and area chart combo
Is it possible to create a stacked area and area combo chart. I have 2 
 
series that need to be stacked and one that needs to be just area. If I 
 
change the one, it changes all.
Read Entire Conversation

Capturing Equations From Charts
I have created a chart that displays Space vs Sales for a given 
 
department for a number of stores for the company I work for. To this I 
 
have applied a logarithmic trendline to show the curve of how sales 
 
change with changes in space & have displayed the equation for this 
 
line. 
 
What I am wondering is, is there a way to capture this equation in to 
 
an Excel cell without manually cutting & pasting it? I have to create a 
 
number of these charts for different departments & need to  ...
Read Entire Conversation

In Excel, can you set up text that will magnify with the cursor?
There is a report I repair that contains a great deal of text that needs to 
 
appear on one page. I am trying to set it up to where each cell will magnify 
 
when you drag the cursor over it. I do not know if this is possible.
Read Entire Conversation

is there any limitation to the quantity of line groups?
In a line chart, when the quantity of the line groups is over 12,  the line 
 
and its data will not coherent with each other? what is the problem?
Read Entire Conversation

R-squared from a trendline
What is the difference between (1) the R-squared value generated when you add 
 
a linear trendline on a chart and (2) the R-squared value generated when you 
 
do regression in the Data Analysis add-in?
Read Entire Conversation

X axis label problems...won't display
My x axis labels are very long, up to 70 characters.  I wish I could 
 
shorten these, but they have already been published by previous 
 
authors.  We have to use what was published. 
 
I can't get the entire text to show.  I've tried changing the size of 
 
the font or the text direction.  I've also tried resizing the plot 
 
area, but the amount of space allowed for the x-axis labels is fixed. 
 
I've made the plot area very small, and the text is still cut off at 
 
the exact same point when ...
Read Entire Conversation