|
|
xl2007 - Reading Values and XValues by
Greg Wilson
You cannot to my knowledge directly querry the XValues or Values from a chart
series. For example, this does NOT work:
Sub test1()
Dim i As Integer
With...
|
|
0 |
140 |
|
|
merge named ranges ? by
rolando
I have a sheet with data in column A, e.g. rows 1 to 100 all have data, but
row 10 to 30 need to be excluded because invalid (but are not empry!). This...
|
March 1st, 2009 10:04 AM
by rolando
|
2 |
161 |
|
|
Trouble. by
Mark
I'm having trouble looking the DBF4 in the Files of Type window. I'm suppose
to save a document in Excel into dbf format. How do a save an Excel document
in...
|
|
1 |
140 |
|
|
Trendline partial data start point by
JJ@Mich
I was able to create a linear trendline for only portion of the data in my
pareto (by adding new series), but the line always starts at the beginning of
the...
|
|
1 |
209 |
|
|
|
|
2 |
265 |
|
|
Information on both sides of a chart by
Té
How can I create a chart that has a value x,y, and z axis. I want to put
numbers on the left side of the chart, at the bottom, as well as on the right
side. ...
|
|
2 |
293 |
|
|
More trendlines? by
Don Culp
Are there any add-ins to Excel 2003 that include more trendlines? Preferably
the add-in would have the option to search through its available trendlines
to...
|
February 27th, 2009 04:26 PM
by Don Culp
|
3 |
242 |
|
|
Trendline values by
Scott
I used the function "LOGEST" to get an exponential fit of a series of
numbers, which gives me a value of 1.0610. I also used "RSQ" function to get
the...
|
February 27th, 2009 03:54 PM
by Scott
|
2 |
200 |
|
|
ALIGNING THE X AXIS DIAGONLLY by
L challenged
I am trying to align the x axis on a chart diagonally. When I go into the
format axis dialogue box and click on alignment the custom degree box is
greyed...
|
|
1 |
235 |
|
|
Excel Charts by
Raiju
Hi , I have a range of sales data from 1 - 30 of a month, i will select the
all range while creating chart.What i want when click on the chart it could...
|
|
6 |
182 |
|
|
Flow Chart - Excel 2007 by
Nicola
I'd like to creat a flow chart in Excel 2007 but not having much luck
Can anyone help please
Thank you
|
|
2 |
154 |
|
|
Charting 2 Sets of Data by
Darin
I have 2 sets of data. One set is in Billions (AUM) and I would like to have
that be a bar chart. I would also like a line through the data that show...
|
February 26th, 2009 06:02 PM
by Darin
|
1 |
158 |
|
|
how to make an XYY graph by
Jeff Lynum
I want to compare to sets of numbers like temperature and relative humidity
for given times. I need each y-axis to have a different label and set of...
|
February 26th, 2009 05:57 PM
by Luke M
|
2 |
219 |
|
|
Charts by
rkohelp
Trying to compare customers purchases by month and by year. Stack customers
and have each month beside each other. how would this be set up
|
February 26th, 2009 03:52 PM
by rkohelp
|
0 |
99 |
|
|
|
|
1 |
175 |
|
|
Fishing For Chart Ideas by
smartin
Up front, here's a sample of what I came up with:
http://vfdrake.home.comcast.net/~vfdrake/files/excel/crwp.pdf
I am looking for suggestions to improve this...
|
February 26th, 2009 01:18 AM
by smartin
|
4 |
151 |
|
|
Graph points going to zero by
kajones
How do I keep my chart line from dropping to zero for the upcoming weeks that
do not have data. I am using a formula to calculate my 52 week progress. The...
|
|
4 |
116 |
|
|
exclude blank cells in a line graph by
Whitehorn
I've seen some good threads to exclude blank cells from an excel line graph
by using NA()) instead of "". However, how do I accomodate cells that could
= 0?
|
|
2 |
183 |
|
|
|
|
1 |
268 |
|
|
|
February 25th, 2009 03:46 PM
by Melissa
|
0 |
149 |