add a data label
How do i add a data label for my y-axis on a line graph created in word?
I presume the Word chart has been created with MS Chart? If so Double-click
to activate the edit mode for the chart, then choose Chart, Chart Options,
If the chart is an Excel Object then you use the same steps.
> How do i add a data label for my y-axis on a line graph created in word?
...Excel 2007 Chart in VB6 Program
I have another thread in the VB group and was told to post to these two
groups so sorryfor the multi-post. Ill post there again just in case folks
want to follow the thread.
So I've had a Visual Basic 6 app (as an EXE) that has worked great for the
last 9 years or so. Up until Excel 2003 I have had to make minimial changes
it to work properly. The app has an OLE control which acts as a container
different external sources .In this control I embed an Excel workbook and
display a chart sheet. I can interact with the workbook through the normal
Excel programming objects...how do I recover charts within an excel workbook?
The workbook had many charts that were previously visible. Now, upon opening
the file, the charts are no longer visible. How to I reactivate them to
...Problem with Asset Allocator pie charts
Everything "seems" to be working fine with Money 2005
Premium (after restarting the program multiple times).
I'm having a problem with many of the pie charts. They
do not show up at all. I upgraded from Money 2004. Any
I'm running Windows XP Professional if that's of any
I've seen them going on a new file on Win XP Pro - do you get them on a new
file, or do they not appear on both a new and old one?
Glyn Simpson, Microsoft MVP - Money
Check http://support.microsoft.com/default.aspx?scid=fh;EN-GB;...how do i add all my suggested contacts to my contacts list?
How do i add all of my suggested contacts to my plain old contact list?
Are you asking about a beta?
"Teagan" <Teagan@discussions.microsoft.com> wrote in message
> How do i add all of my suggested contacts to my plain old contact list?
CTRL+A to select all of them then just drag and drop...
Ben M. Schorr, MVP
Roland Schorr & Tower
Aut...Draw line in a chart
I have the following problem. I have a chart (date on x axis) on which I
draw a line. How can I obtain the ending points of the line in order to
compare, mathematically, their positions to corresponding values of
chart at the same date?
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements
I'm sure your post makes perfect sense to you and might to other
readers, but I am los...Data Analysis Plus Add-In
My Data Analysis Plus add-in has disappeared. I had it
installed at one time, but now it is gone. I've
attempted to reinstall the add-in several times and
rebooted each time, but to no avail. Running XP Pro and
Office Pro software. Any ideas?
You probably have done this but .... have you looked at Tools/Addins .
there is a Browse button in case Excel cannot find it
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
...how to chart who was working when
Hi there, I'm looking for some help in producing a chart. My
organization has hired about 100 folks since 1991, each on contracts of
varying lengths of time. Some peoples' contracts have ended, and some
have been renewed. I set up some worksheets inputting their names,
start and end dates with the intent of producing a graph that will tell
me exactly how many people were working for us at one time, based upon
6 month intervals. For example:
John Doe 7/29/91 - 3/31/05
Jane Doe 6/21/94 - 2/20/96
Jake Doe 8/2/01 - 4/18/03
I would like a chart that can tell me how many people w...Pivot Chart: Stop skipping Dates on X-Axis
I have a pivot chart which pulls 2 pieces of information from one table 1 and
1 from Table 2. All three entries are included for each day. Except somedays
which may have only the one piece of data from Table 2 or none at all. How do
I get the table to automatically fill in all the days whether they have
information or not?
=?Utf-8?B?UHJpbmNl?= <Prince@discussions.microsoft.com> wrote in
> I have a pivot chart which pulls 2 pieces of information from one
> table 1 and 1 from Table 2. All three entries are included for
I have an excel workbook file containing many department sales charts that
recieve data from a group of central data entry spreadsheets. Each
department chart resides on its own sheet. Is there a way to email
individual chart sheets (or snapshots of the chart sheet) to the respective
departments without sending the entire parent file to all recipients?
You could export the chart as a gif file, then email that file to the
department. The following code creates a gif file from the active chart:
ActiveChart.Export Filenam...Pivot charts formatting
I want to change the formatting imposed by default in a pivot chart and I
want that changed formatting to be retained permanently.
For example, for my bar chart, for the different series I have selected
colours / patterns but every time I refresh the pivot table / chart; excel
falls back to its own colour coding.
Any way to get around this?
Many thanks in anticipation.
Not directly. The only way to simulate this is to record a macro of the
formatting changes that you make and then set it up to run whenever the
PivotChart calculates. Assuming your pivot chart is on a seperate shee...Auto Add-on?
Is There a way to get a dialog box to come up with a specifc item asking if
an add on item would like to be purchased?
When a designer dress SKU is entered a dialog box pops up and asks if the
customer would like to purchase a custom printed garment bag for $5.00.
Then press yes to add the additional item and no if not?
The best you can do out of the box is item messages which will only prompt
the cashier, not actually add the item. If you are interested in having
this functionality we could certainly design a custom solution for you. For
more inform...see chart from pushing button
how would I see a chart from pushing a button on the spreedsheet ?
...pie-charting non-numeric data
I would like to chart and graph responses to a survey that are non-numeric in
nature, such as a bar graph for "yes" and no" responses to a question. Or in
particular a pie chart that shows how many people picked option "P" vs. "K",
"J" or "N". For the pie chart I have a column of data cells, each containing
one of the four letters.
In short, how do I accomplish charting and/or graphing non-numeric responses?
So you have a column of Yes/No or P/K or J/N? Construct a pivot table of this range,
and you can produce counts of each value...Excel 2003: How to make transparent columns in Excel chart?
If you create a bar plot froma given dataset you can format the
columns by right clicking and choosing the desired options. In the tab
that opens there is a slider which is supposed tho set the level of
transparency of the column (selceted area). But so far i couldn't find
a way how to use this slider.
I know that there is an alternative way to get transparent bars by
creating a rectangular object formating it and the use copy -> paste.
But i wonder what is the slider for if you can't use it?
Does anybody know have an idea?
...Switching x-axis & y-axis on line chart
I am working with a large data spreadsheet with year,
number and currency data. My problem is when I extract
data to create a standard line chart, the chart is
defaulting to a specific x-axis and y-axis format with
data related to each axis. For visualization purposes, I
would prefer to have the data that is currently presented
on the x-axis to instead be presented on the y-axis. And
likewise, I would like the y-axis data be presented in the
x-axis. However, I have been unable to figure out how to
do this and the MS Excel Help menu does not seem to
address this. Can anyone help?
If ...Add values in a column according to value in another column
How can I add the values in a column according to values in another
column? If there is any value in a row in column B, I want to include
the value of the corresponding row in column A. I'm flexible as to
whether this is ANY value (i.e. not empty) or greater than zero.
Maybe something like this =IF(B1="","",IF(B1>0,B1+A1))
"Paul Kaye" <firstname.lastname@example.org> wrote in message
> How can I add the values in a column according to values in another
> colu...Stack Bar Charts
I have yearly information that I would like to graph in a stacked bar chart.
I have years 2005 to present
Two companies I am comparing with two variables for each company each year.
I would like to have the stack bar chart by year reflect the stack of Co A
vs Co B on variable 1 + 2.
Any help would be appreciated.
You want a clustered-stacked chart:
Peltier Technical Services, Inc.
> ...personal income and expenditure chart
can anybody give me a personal income and expediture chart please
> can anybody give me a personal income and expediture chart please
> Thanks Mike
You can do this in Excel but why re-invent the wheel? Quicken or
Money have far more tools and options. If money is an issue try
checking ebay. I purchased Quicken 2004 for about $10 including
shipping. It isn't the latest and greatest but it does what I
need it to do.
...How to add newsreader to Outlook 2003 with SP1?
I'm trying to follow the instructions of Start the newsgroup reader. But I
cannot find the News command in the command list of the Go menu. I'm using
Outlook 2003 with SP1.
To get the News command back, go back to the Programs tab in Control Panel |
Internet Options and change the default newsreader to Outlook Express. If
OE prompts you to make it your default newsreader the next time you launch
it, clear the "Always perform this check..." box and then click the No
"Peter" <Peter@discussions.microsoft.com&...Add Text Together for Report
I tried to search for this one but not sure how to word it.
What I am trying to figure out is how to make a report that adds all the text
from a query together and displays it in one field.
I have a table that gets me the following data.
deconid logdate log
14 12/06/2007 This is just a test
14 12/07/2007 yes.. This is a log
14 12/08/2007 Yet a log number three
14 12/09/2007 This is number 4
I would like it to display this data in a report like this:
With DeconID 14,
"12/09/2007- This is number 4 ~ 12/08/2007- yes.. Yet a log number three ~
12/07/2007-...Chart drilldown to data
I have a client that has MS Excel 2000 bar charts made from worksheet data
He wants to be able to click on a chart object such as a bar and have the
source data come to the front.
I have tried to put buttons over the chart but I can't change the button
color to match the chart.
I can change the chart bar to be the gray color of the button but that is
Is their a way to send the button to the back behind the chart and still get
the button to respond to a click?
Is there any way to turn a worksheet cell into a button?
The only way I can see is to place a button ov...Charting challenge/query
The following quote is posted on behalf of a client using Windows and
Office 2003 Standard. Please email responses directly to me, too,
since I do not read this group much.
Any help/insight would be most appreciated. I'll do my best to relay
any questions people have and bring back any answers to said questions.
In an effort to come up with a new way of looking at organizational
structure, I employed Excel's 'Donut Chart' function. My goal was to
have the head of the organization in the middle of the chart and then
that person's direct re...How to "freeze" chart & separate it from it's Data
I would like to produce a chart and then rearrange the data to produce a
separate chart. Is there a way of separating a chart from it's data so that
I can take the data and after rearrangement, produce another chart?
Here is some information on how to de-link chart and data.
Andy Pope, Microsoft MVP - Excel
"Rooky228" <Rooky228@discussions.microsoft.com> wrote in message
>I would like to produce a c...add public folder calendar to multiple user accounts favorite calendar list. 06-22-10
i need to add a public folder calendar to multiple user accounts
"favorites" calendar list (shows as other calendars) in outlook 2007.
i know, from outlook, you can right click and add to favorite to add
it to an individual user's "other calendars" but i need to do this for
a group of people. is there any way in exchange, gpo, or something to
do this automatically based on group membership, etc.? thanks in