Edit Pie Chart Data Label
I am using a pie chart to detail a subset of data and I am having trouble
getting the chart to display the data I need. For example:
Fruit equals 25% of overall diet.
Within fruit I ate:
Fruit # Eaten % of Overall Diet
Apples 10 10%
Oranges 8 8%
Pears 7 7%
I want to graph fruit consumption in pie chart and add all information to
the data label using a link.
I get this to work (click on data label and add location of cells), but I
can't get it to display properly. I am getting
but I...How do I create a combination chart and table with different data.
I am using Windows XP, and Microsoft Excel 2003. I have been asked to create
scorecards with charts displaying rates graphically, and an attached table
underneath with numerator and denominator data. The combination graphs in
the custom charts try to graph and display all the data. Can I create a
combination chart with the rates graphically displayed and the underlying
numerator/denominator data presented in a linked table underneath the chart?
Or do I need to create the graph and table separately?
You would do better to make a separate chart and table, because chart data
tables ...Use first day of month formula in a drop down list
I'm using the formula =DATE(YEAR(B4),MONTH(B4),1) where cell B4 = Today()
and this works to give me the 1st day of the current month.
My question is:
How do I use this in a drop down list on a separate worksheet in the same
workbook? I have tried to name the cell containing the 'date' formula, but it
looks like Excel does not allow naming a cell with a formula. Each time I
name the cell (select the cell, click on the 'name box', type name, enter)
when I re-select the cell it hasn't changed the cell name. It defaults back
to the row/column name.
Than...Count off calculated fields
We run Access 2003
I have a report for salespersons which lists all salepersons and the total
sales each one made for each week of the month. There are 5 fields on the
line, one per week of the month.
E.g. John Doe Wk1Sales Wk2Sales Wk3Sales Wk4Sale Wk5Sales
Each of the Wk#Sales textboxes get fed by a function that runs a dsum
function over the database.
All sales persons will appear whether or not they met the quota for every
week of the month
How do I calculate the number of salespersons who met their weekly quota for
ALL weeks of the month. Using the average o...Can a mouseover reveal associated data in charts?
I want the associated cost display on the chart when you mouseover each
data point (representing number of units). Does anyone know how to do
JLC's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28014
View this thread: http://www.excelforum.com/showthread.php?threadid=475576
Mouseover on my (XL2003) charts always shows values (and a bit more:
x-coordinate and series name).
I seem to recall it did in XL200 and XL97, too.
--------------------------------...Related Data Between 2 Different Workbooks
I need to create 2 workbooks, which have data relationships.
I don't know how to get data connect when I change data in the first
workbook, this data will also be automatically changed in the second
Please give me a hand. Thank you very much and I am looking forward to
hearing from you.
freeecoom's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27507
View this thread: http://www.excelforum.com/showthread.php?threadid=470378
On...Report List not displayed
When I go to the reports menu - Reports Section ->
Account Reports - the report list is not displayed.
There is just a blank page.
Does anyone know why the reports are not displayed?
Its OK, they are back.
I had to restart the Crystal Services.
>When I go to the reports menu - Reports Section ->
>Account Reports - the report list is not displayed.
>There is just a blank page.
>Does anyone know why the reports are not displayed?
...Compare a range of cells
How can i compare a range of cells an have them "reorganized" so that
the one that correspond is listed on the same Row?
Add a header to row 1 and try this macro that I've saved this from a few
Application.ScreenUpdating = False
Dim wks As Worksheet
Dim ColA As Range
Dim ColB As Range
Dim iRow As Long
Dim myCols As Long
Set wks = Worksheets("sheet1")
wks.DisplayPageBreaks = False
Wit...Data Label Format
I have to data labels on a chart that overlap. Is it possible to wrap the
text or change the data label box size so both labels are readable?
Thanks for any help.
...Adding in data based on dates
If I have a historical file in access, and then I recieve a file every week
that has the past 17 days. Is there a way to get access to merge JUST the
past days that are not included in the history.
So you have a report that is from 2/7/05 through 2/7/08. I recieve a report
for 1/28/08 through 2/14/08. I want to just add on the 2/8/08 through 2/14/08
data. Is that possible?
How can I do this?
You should be able to determine the latest date in your History table.
Then filter your import with a Date criteria...input a signal into a cell and count
I wish to detect a signal in to an excel cell via a parallel port, hopefully
I can then count the number of pulses over a period of time. Any help would
be much appreciated
Get a driver/Excel template from your hardware vendor, or use software like
MS Excel MVP
"RL" <RL@discussions.microsoft.com> wrote in message
>I wish to detect a signal in to an excel cell via a parallel port, hopefully
> I can then count the number of pulses over a period of time. Any help...How to export/import an existing Junk email list.
Does anyone know how to export/copy and existing Junk
email senders list from one computer to another. I have
looked in the registry and on the hard drive and cannot
determine where they store the addresses added to this
Thanks Chris. I should have searched the entire drive
reather than "Program Files". Thanks for your help.
>Using FileMon and Regmon from www.sysinternals, I was
>able to monitor both the file system and the registry
>while adding a user to my Junk Email list. It appears
>that the entry in added to ...I can't open Office Data File from CDs #2
Dear technical experts,
I have been facing a security problem with Microsoft
Outlook files. I exported Outlook items into Office
outlook files (with the extension is .pst). The exported
files were firstly saved on my computer (different path
and location in comparison with default path of Office
Outlook files in Documents and Settings). I can open my
exported files easily.
Because the size of outlook items is very large, I would
like to save Office outlook files on another storage
device in stead of using hard drives of my computer. I
made copy these files to a flash drive (USB dri...Values in List Box
I have a multi select list box control on a form and I need to return the
values of highlighted multi select items. Code
For Each varItem In .ItemsSelected
If Not IsNull(varItem) Then
In this, I need to return the values that are selected in the list box.
Using Me.lstExtractRouteMulti.Value returns Null
Using Me.lstExtractRouteMulti.Value returns Null
Yes it does because it is a multi select list box.
In the code you posted, yo...Charting Selective Data
I am trying to create a chart of monthly percent gain across a given
year, and I have separated the data into two rows:
Jan Feb Mar Apr ........... Dec
#N/A #N/A 5% 12% .......... 0%
The #N/A signifies that there is no data for the given months, and the
0% signifies that the month is not completed. They are a result of the
formula being used to grab the data.
I'm not sure of what method is the best, but I simply want a chart
that only displays the months that contain a percent value (other than
0%). Any help would be greatly appreciated with this problem.
Than...Identify Whole Number
How can excel identify a number when it is whole or it has decimals.
I am doing an IF function.
If(A1=WHOLE NUMBER, YES, NO)
Is there some way?
"ileanardz" <email@example.com> wrote in message
> How can excel identify a number when it is whole or it has decimals.
> I am doing an IF function.
> If(A1=WHOLE NUMBER, YES, NO)
> Is there some way?
=IF(INT(A1)=A1,"YES",&...Payables MGmnt GP 10 year end close
Does anyone know what the steps are to clsoe AP, I don't think you need to
do a hard close, my problem is this
I set up 2010 fiscal periods and had they a/p clerk post a/pto 2010, problem
is when i go into financial inquiry detail or summary I have no transactions
for 2010 even though posting date was 2010, is there another steop i must do
in order for 2010 transactions to show up? Can some on help us, my email; is
firstname.lastname@example.org any help would be great, Thanks
Have you looked into any unposted batch in GL? The resulting GL batch
remained unpost...import data from goldmine
Does anyone know how to import data (customer contact) from goldmine to CRM?
Thank you very much.
Yes, we used Scribe data importing tool.
"Qnguyen" <Qnguyen@discussions.microsoft.com> wrote in message
> Does anyone know how to import data (customer contact) from goldmine to
> Thank you very much.
A bit of a typo.it is www.scribesoft.com .
What are the things which you want imported from Goldmine? If it is not too
exhaustive then you...Word was unable to open the data source
My problem is that my Excel data is not being "mail merged" into Word. I
followed the suggestion of prompting the data source before opening and I can
choose "MS Excel Worksheet via DDE (*.xls) when prompted. Next I choose th
named or cell range which is "Entire Spreadsheet". Then in lowr left task
bar it briefly says "Opening file . . . ." but then I am prompted with Word
error "Word was unable to open the data source."
If I try Office 2007 I use "OLE DB Database Files" when prompted to open
data source. Then I select t...Converting mysql query result to xml
Hi all, I'm a newbie in .net xml programming, so please be patient. And
sorry for my uncorrect english, too.
I'm going to explain my problem:
I've built a web service which responds to ferries timetable requests.
It receives an xml document with this format:
when i enter a number in a cell in excel 2003 worksheet appear in the cell
as the number divide par 1000
e.g. I enter the number 1 in a cell
when I <ENTER>, in the cell appear 0,001
Who can my help
Goto Tools>Options and on the Edit tab there is a checkbox for Fixed
Decimal. Uncheck that box.
(replace xxxx in the email address with gmail if mailing direct)
"nieuws" <email@example.com> wrote in message
> when i enter a number in a cell in excel 2003 worksheet appear in...Excel changes the values of my numbers
I have coded a simple user form in Excel that calculates a balance an
assigns the proper values to cells in a worksheet. What I don'
understand is that when I enter a number into the user form, the valu
of that number changes once it gets assigned to the cell in th
worksheet. For example, if I enter the number 542.73 ,the user for
assigns the number to the proper cell in the worksheet but it shows u
as 542.72998046875. It should show up as 542.73 because that's what
entered. I am calculating a running balance so my calculations aren'
coming out right. Sometimes they are off ...Data Entry problem #2
When I enter numbers into spreadsheets they get changed to two decimal points
(e.g. 250 = 2.5). I know there must be some global setting, but I don't know
where. Can anyone help?
Ctrl+A to select the entire sheet. Then format>cells>number tab
Tools>options>Edit tab>uncheck the fixed decimals box
"Bob Shepard" wrote:
> When I enter numbers into spreadsheets they get changed to two decimal points
> (e.g. 250 = 2.5). I know there must be some global setting, but I don't know
> where. Can anyone help?
Just had...Best practice to modify list during iteration
Hi, I'm writing a scheduling class. On each clock tick, I scan the
trigger list to see which if any triggers have been activated. If so,
execute the callback and if it is a periodic trigger to reinsert it in
the list at some future time. So it's a matter of removing and possibly
adding the trigger within the same function. I don't that you can modify
the list while enumerating it - ie: psuedocode
foreach (trigger in triggers)
if (trigger is Periodic)
reinsert in list)
so I scan the list, find the active triggers, use trigg...Add Item to Data List that has Dynamic Source
I have a dynamic drop down list that refers to a long column of names, sorted
alphabetically. The list will size itself depending on the letters entered
into a reference cell (A1). ResList is a named range that references to the
column origin, and ResName is the dynamic named range of the column of names.
The source equation is this:
Question: is it possible to insert a blank as the first selectable item in
the resulting list - without VB?
A possible o...