creating a chart not working
my charts all come out with just gray lines no matter what I do, I know I am
setting it up wrong, but have tried several ways, is there a trick?
is this when you print it or on your display?
make sure your print options say to pringt in color and not grayscale.
> my charts all come out with just gray lines no matter what I do, I know I am
> setting it up wrong, but have tried several ways, is there a trick?
...How to convert CString object to data type?
How can I convert CString from a EDIT control Dialog to data type for
Take a look at _stscanf/_ttoi.
Y Xu wrote:
> How can I convert CString from a EDIT control Dialog to data type for
Hi Y Xu,
Can you be more specific , what type do you want it to be converted to
Y Xu wrote:
> How can I convert CString from a EDIT control Dialog to data type for
On 8 Jun 2006 07:31:57 -0700, email@example.com wrote:
>Hi Y Xu,
>Can you be more specific , what t...Sum of data on a per month basis
I can't figure out how to do this. I think SUMPRODUCT might be the
key but I can not figure it out.
I need to extract the monthly sums of expenses incurred from a range
The data set has two columns Date and Price.
The data changes throughout the year and I have had to adjust the sums
ranges by hand and it has led to some human error on my part.
Using functions I want to be able to automatically get total each
month without manually having to adjust the ranges in the data set.
I am using Excel 2007.
Thanks so much.
Suppose your dates are in column D and your expenses in co...Range formula possible to update summary page with new entries when new sheets created?
I'm not sure what this would entail but is there a way to fix our summary
pages to include formulas or whatever that more automatically update links
from the sheets linked to them when new sheets are added to each workbook?
The reason I ask is because my colleagues are dealing with four workbooks
that each have about 15 worksheets minimum. Every time a new employee is
hired, a new employee sheet is created by copying one from another employee
and modifying the entries to reflect the new person. Unfortunately, the
summary sheet doesn't automatically include working links when they co...How do you set all graph data points to black (multiple series)?
I have multiple series on a chart, all with different marker shapes as
desired. How do I globally set all the data point colors to black without
picking each series in turn and setting a custom color.
You can't do it using the native Excel interface, but a little macro
will handle it:
Dim srs As Series
For Each srs In ActiveChart.SeriesCollection
srs.Border.ColorIndex = 1
srs.MarkerBackgroundColorIndex = 1
srs.MarkerForegroundColorIndex = 1
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and ...man-hour chart.
i have a question.
i am working for an office. Where i have 32 labors, working under 4 seniors. i want to create an individual man hour chart and an individual budge chart for all the 7 seniors. What all fields i should include? And what are the formulas? Can i somehow relate these two charts?
hope my question make sense.
EggHeadCafe - Software Developer Portal of Choice
Dr. Dotnetsky's Cool .NET Tips and Tricks #17
...Name Range with using Data Form
I first created a variable with A1:D1, four columns with named variable
Data. How to expand this Data range to A1:D2 after using the DataForm to add
one row data in the worksheet?? The same, the Data range should be A1:D3
when adding one more data row...
use the following formula in the name definition dialog
>I first created a variable with A1:D1, four columns with
>Data. How to expand this Data range to A1:D2 after using
the DataForm to add
>one row data in the worksheet?? The...Concatenate mid, left then right data
I have searched other messages and my brain must be on holiday because
I cannot get any of the answers I found to work for me.
What I have is a column of data which has to now be changed for GL
Reconciliation, looks like this-
And I now need it to look like this-
Most probably very simple but it still eludes me.....
Any help would be much appreciated.
","...Why do Data markers in Excel 2003 appear to be bold?
When crating charts in Excell 2003 the Data Markers (numerous points) appear
to be bold and blurry. This does not occur in Excel XP. Marker size is set
...How do I link columns so data flows from 1 column to another like.
Is there a way to link columns in Excel, so that data that's entered flows
from one column to the next? There's a function similar to this in Quark.
Anybody know anything about this?
If I understand the question correctly, and the information is being typed
into the cells, you could try this:
Select a block of cells, say A2:C10
Then, type a value. Press enter. If yuo press enter after each value
entered, when you enter a value in A:10 and press enter, you're active cell
will be B2.
"M. Frazel" wrote:
> Is there a way to link columns in Excel, so t...Changes on Chart
I am aware that any change in the data table will automatically changes the
linked chart, is there any programm in Excel that can do this the other way
around, i.e that gives the possibility of changing the shape of the chart on
the chart itself rather than on the data table so that data table changes
automatically with the change on the shape of the graph?
In older version of excel, not xl2007, the chart had a goal seek
function. You could grab a point and move it in either the horizontal or
vertical plane. The linked cell would automatically be updated.
For an xy-scatt...Exclude data from field, when another field equals a certain numbe
I have 2 fields. I have Job # and GL #.
I need to exclude from the GL field, values that are 1234, but ONLY if the
Job # = 999999.
I have tried using this formula in the criteria of the GL# field in my query:
IIf([Job #]=999999,<>1234,[GL #])
and instead of 999999 still showing up in the query and excluding GL# 1234,
999999 doesn't show up at all!
What am I doing wrong??
IIf([Job #]<>999999, [GL #], IIf([GL #]=1234, Null, [GL #]))
I'm assuming by exclude that you mean Null.
Jerry Whittle, Microsoft Acce...Opening disk containing Excel worksheet
I saved an Excel worksheet to a disk in the a drive.
Later I opened it to edited the material, then resaved it
to the disk. When I tried to open it again, it would not
open. I received an error message stating that "The file
may be read-only or you may be trying to access a read-
only location." Other files on the disk do open. How
can I either open the file, or at least access the
contents so that I can have it retyped?
I find the following thread to be fairly comprehensive.
http://groups.google.com/groups?hl=en&lr=lang_en&ie=UTF-8&oe=UTF-8&safe=off&...Data Charting Correctly
We are working with a table that has a Sell Price, List Price, and Profit
Margin. When we try to chart it, it looks like it is adding the "Sell Price"
and "List Price". The "Sell Price" which is in row 1, is plotted correctly.
The "List Price" looks to be the total of the two. The "Profit Margin" is
plotting with the "List Price".
Is it in the way we have selected the table to chart? Does anyone have any
Choose the line chart option in the first column, not the stacked line chart
option in the second.
...How do I create an alert of expiration date in Excel?
I created a spreadsheet to track documents. The last column is for
expiration dates of documents. How can I set up an alert when the expiration
date is approaching?
Use conditional formatting in the cell. For example, with the date in A12,
Formula is =TODAY()+7>=$A$12
as the condition.
Then choose a pattern.
> I created a spreadsheet to track documents. The last column is for
> expiration dates of documents. How can I set up an alert when the expiration
> date is approaching?
I'm trying to build an org chart from an access 2000 database using Visio
2000. The database contains Greek text fields. The text appears as question
marks. Anyone know how to do this ?
I'm not sure you will get answers from this forum... I have asked the same
question in multiple ways, but no one ever addresses the basic question: Why
can't Visio access, use, print, view, or otherwise deal with any other font
type than TTF, and even if it a TTF, only the first 256 characters of the
font can be used (which makes useless the Unicode logic). (see previous
I have had to w...Problem with mixed trend and XY chart
I have a number of large spreadsheets used for analysing quality data
On each table there are several trend charts showing results over time
On each chart I have also added control limits set up as XY ranges.
Initially all worked well.....but..... for some reason when I filte
the lists now (to select specific products) the x axis labels (set u
as a named range) expand to fill most of the graph space.
Without the XY ranges it all works fine but with them in place i
doesnt. When I check the axis format I also find that I can no longe
change the number of categories between tick marks.
What am...Colouring Chart backgrounds
I would like to colour the background of a chart with 3
different horizontal stripes of colour. I have tried
drawing 3 rectangles on it but cannot send it to the back,
therefore it covers my actual chart info.
Is there a way of doing this?
Take a look at Jon Peltier's example, you should be able to adapt it.
> I would like to colour the background of a chart with 3
> different horizontal stripes of colour. I have tried
&...import data from access table into a existing table
I need to map data from am existing access database into a existing staging
database. The access database only has the data I need, so the mapping is not
a one to one, The SQL table many more columns so I need to do some manual
mapping. Is there a way to do this throiugh the import wizard or do I need to
write some type of query to manual insert the data?
Thanks in advance.
Message posted via SQLMonster.com
This is SQL Server forum, you will be better of to ask on Access forum
"Jay via SQL...Static reference to worksheet in formula
I have several Documents. For example one is called Budget 2007, Budget
2008. In each of these I have worksheets for each month, Jan, Feb, etc... I
also have a worksheet called Year. In the Year I have cells that reference
the month worksheets. For example I might have =Jan!$B23
My problem is that when I now copy the worksheet Year to the new file the
cell reference is ='C:\[BUDGET 2007.xls]Jan'!$B$23
I can't edit the links because I do have some formulas which I want to
reference previous years and otherwise will create lots of circular
2 questions I have.
1)...Is it possible to create a mailing list in excel, not importing d.
I would like to create a mailing list in excel, entering each address in, not
importing it from somewhere. Can excel do that? Or do I have to import the
data, entering the addresses in a different software and doing some sort of
mail merge with excel? Thank you in advance for your answer.
If you have addresses in excel you can use word to mailmerge and use excel
"Claire Bardot" <Claire Bardot@discussions.microsoft.com> wrote in message
news:C0BE56B4-AC5A-4D08-85E1-D6C262EE6080@mi...Want to create sliders to change cell values in EXCEL for PC
As a math teacher, being able to view chart/graph changes as equation
parameters change is an extremely valuable tool. An article in the NCTM
Mathematics journal describes this capability using "Scroll Bar type Sliders"
in EXCEL 2004, which is evidently for MAC's. I have a PC with EXCEL 2003.
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 th...Pulling data from one sheet to another
I'm having problems with retrieving certain data from one sheet to another and I don't know if it is possible.
See the below data as an example of what I'm using:
VERSID DOC LH EN VELS COUNT
1233 Duplex 100 500 503 G
1233 Duplex 101 501 520 I
1675 Simplex 100,105 500 520 G
1675 Simplex 101,106 501 503 I
1674 Simplex 100,105 500 520 G
1674 Simplex 101,106 501 503 I
Versid numbers are unique to each set of data, however the sheet I want to tie this up with use a different set ...Data Validation to range names for Chart Source Data
I have 15 Named Ranges. I'd like to have a drop down above one chart to
select one of the names and the chart updates. How?
It sounds like a pivot chart would give you the dynamic ability you are
looking for. If you build a Pivot table and chart you can drag the series
that you would like into the data range or have them on top to filter by.
Another option would be to use an advanced filter for your data. Using this
would also change the chart as you changed the filter.
> I have 15 Named Ranges. I'd like to have a drop down ...Line chart with value on the line
I have implement a line chart by thousands of data rows for a stock.
Now I want to show values on 10 particular points with the lable
E.g, one extra column for displaying the label.
TradeDate Ticker Close Label
04/01/1999 1234 63.67
05/01/1999 1234 63
06/01/1999 1234 63 Mr. A buy
07/01/1999 1234 67.33
08/01/1999 1234 68.33
11/01/1999 1234 68.67 Mr. B buy
Does anyone teach me how to do this ??
"Ginola" <firstname.lastname@example.org> schrieb im Newsbeitrag
> I have implement a line chart b...