How do I set up a daily average of unit sales formula
More info required.
(remove nothere from the email address if mailing direct)
"jim m" <jim firstname.lastname@example.org> wrote in message
...Can I copy radio buttons so that the second set is independent of.
I have a group of four radio buttons that all point to one cell. My goal is
to create a second set that looks identical to the first but which points to
a second cell. This is for a questionaire that will have many questions with
the same four answer values. I want to be able to quickly create 100 button
groups that will each update a separate cell for scoring of the questionaire.
There are optionbuttons on the Control toolbox toolbar and there are
optionbuttons on the Forms toolbar.
Each has different behaviors.
If I had to use lots, I'd use the Forms version.
Here's a pos...100% stacked column chart shows wrong information
I wonder if someone can help me. I have created a table that tracks the
profitability of a particular project and I’m using the table as a source for
a 100% Stacked Column graph.
The source data for the graph is in three rows:
• B21:M21 - contain the names of the months from Nov – Oct
• B22:M22 - money taken in
• B24:M24 - profit
B23:M23 contains the money paid to supplier each month. I need this in the
table but I don’t need to show it in the graph. I just want to show profit as
a proportion of what we bill to customers on that project.
My problem is that the graph seems to show in...fiscal year setting question
i know that the fiscal year settings get more or less set in stone, so i had
a quick question before i set it for my org.
in the template field, what is that used for? if i select 'quarterly', does
that mean i can only run reports on a quarter basis? what if i wanted to do
ultimately, my question is what is the 'template' field used for?
Fiscal year setting must be aligned to your company's accountig policy.
Fiscal year setting primarily defines sales quotas. When you set quarterly
periods, you can set quarterly quotas for mem...Queries and Charts
Does anyone know why the expressions in queries work fine for reports but not
...Can the data in a chart table be right justified?
Ecxel 2003 and previous versions of the product center the data in the data
columns. Can the data in the columns of a chart table be right justified?
In article <DABF738B-6C0D-458B-B082-FA9BD8F126A7@microsoft.com>, =?Utf-
8?B?c2FtIGVhZ2xl?= <sam email@example.com> says...
> Ecxel 2003 and previous versions of the product center the data in the data
> columns. Can the data in the columns of a chart table be right justified?
Have you tried to format the table? If yes, and you haven't been
successful it is probably because XL allows very limited cust...Data migration - Adventure Works
I have a company where the adventure works db has been used and had a
lot of data populated into the system. We have now purchased MSCRM and
have obtained the company reg keys.
What is the easiest way to get the data from the 1 system to the next?
We will be establishing a new AD domain and users for the new
Data Migration Framework?
Microsoft CRM MVP
"funboy...Outlook set up
In MS Outlook 2002: When I send an email, it has my email
address in the from field. People receiving it cant tell
it is from me, and it gets deleted. How can I make MY
NAME appear in that from field instead of my email address?
On Mon, 19 Jan 2004 11:17:36 -0800, "etata"
>In MS Outlook 2002: When I send an email, it has my email
>address in the from field. People receiving it cant tell
>it is from me, and it gets deleted. How can I make MY
>NAME appear in that from field instead of my email address?
Just a...set print area #2
Where is the "set print area" button in Excel 2002 that was in Excel '97?
> Where is the "set print area" button in Excel 2002 that was in Excel '97?
Are you sure it was "standard"? Only way I could get in was to right-click
the toolbar|Customise and drag it to the toolbar from Commands|File
...Updating a chart Automatically
Hi, i update a spreadsheet with new data from Access
everyweek. I have a chart that displays the last thrity
days, how do i do this automatically, so i dont have to
keep updating the chart manually ?
Thanks in advance Jay
Jay Richardson wrote:
> Hi, i update a spreadsheet with new data from Access
> everyweek. I have a chart that displays the last thrity
> days, how do i do this automatically, so i dont have to
> keep updating the chart manually ?
> Thanks in advance Jay
See www.tushar-mehta.com, Dynamic Charts.
dvt at psu dot edu
...Label a chart of counts with other percentage data
Here's the data:
Group 2005 2006 2007 LTM Data
A 19.4% 22.8% 21.2% 19.9% Profitability
A 6 7 7 7 Count
B 9.5% 31.6% 30.4% 30.7% Profitability
B 2 3 3 3 Count
C 22.4% 23.6% 16.6% 17.6% Profitability
C 15 16 17 18 Count
D 19.2% 20.5% 15.9% 13.7% Profitability
D 8 8 9 10 Count
I have successfully generated a stacked bar chart that shows the counts per
group by year.
Now I would like to include a label for each group to show profitability for
each group in each year in the 4 stacks. How would I do that?
--...How do I set up a 98% baseline across my chart?
I am trying to show on a bar chart the baseline that represents SLA
requirement of system up time of 98%. How do I do this?
You can find information on adding a datum line here.
Andy Pope, Microsoft MVP - Excel
"Deb" <Deb@discussions.microsoft.com> wrote in message
>I am trying to show on a bar chart the baseline that represents SLA
> requirement of system up time of 98%. How do I do this?
...Creating a chart based on the data in an embedded worksheet
I have a worksheet with several embedded worksheets. I would like to
create a chart based on the data of one of the embedded worksheets
without putting the chart in the embedded worksheet. I have tried
unsuccessfully to do this. I just wondered if anyone knew how to do
You're embedding worksheets within worksheets? Why? Why not just insert
the worksheets in line with the main worksheet? To open or edit the
embedded worksheet, the parent Excel has to open another instance of
Excel, and the chart on the outside of this other instance will never be
able to acce...line chart with NA() values
12 month line chart, with some values being 0.
I am using an if statement that turns any 0 values to #N/A so they do
not show on the graph (which is what I want).
My problem arises when the 0 values fall in the middle of my data.
So for example:
1) data for all months (Jan-Dec), the line shows across all 12
2) I have data for only 6 months (Jul-Dec), the line starts in Jul and
ends in Dec (perfect);
3) When I have data from Jan-Mar, and Oct-Dec, the line connects
between Mar and Oct. I want 2 distinct lines with no line where there
is no data (#N/A).
gri...cell colour change when set markers are reached
i need to get a cell to change colour when markers are reached eg
a qualification lasts 12 months. what i want to do is have the cell change
from yellow to orange to red as the expiry date gets closer.
If column A contains expiry dates then select column A,
=DATEDIF(TODAY(),A1,"m")<1 red for 1 month
Click Add button, formula2:
=DATEDIF(TODAY(),A1,"m")<2 orange for 2 month
Click Add button, formula3:
=DATEDIF(TODAY(),A1,"m")<3 yellow for 3 month
Adjust number of months as you like!
Regards,...Setting appointment start & end time increments format
In Outlook 2002, I can easily set the Day View to display
the time increments in 15 minute blocks, but on the
Appointments form, the Start and End Times available on
the drop-down menus, respectively, are in 30 minute
increment blocks only. How can I set the format for the
appointment page to have the Start and End Times for
appointments have increment time blocks of 15 minutes?
Thanks! My direct email address is:
If you set your appointments in 15 minute blocks
Outlook will start to offer that. It takes a few uses
Nikki Peterson [MVP ...Setting Defaults in New Item Wizard
How can I set a default value in the New Item Wizard? I want to always use a
barcode type that is about 10 down from the top and I want Taxable Item to
always be checked. Help...
Good question, I need an answer too.
"A StanTech Associate" wrote:
> How can I set a default value in the New Item Wizard? I want to always use a
> barcode type that is about 10 down from the top and I want Taxable Item to
> always be checked. Help...
You can set the default sales tax under Manager, File, Configuration, Sales
Tax, Default item tax group.
To set a default barcode type yo...Excel 2007 Line Chart
Is it possible to configure a line chart in Excel 2007 to ignore the
intervals and graph straight to the next value. For example if I have
Jan with the value 1000
Feb with the value 900
March with the value 500
April with the value 0
May with the value 0
June with the value 0
I want the March value to drop directly from 500 to 0 ignoring the
interval to April, I do not want a curved line it must drop directly
to zero then the line is straight across to April.
I have no idea if this is possible, any ideas?
On Tue, 11 Oct 2011 15:40:45 -0700 (PDT), TyreDu...volume settings
I've taken to listening to podcasts on my three WinXP fully updated
computers. I use VLC Media Player. Some podcasts are so quiet that I have to
turn the volume all the way up both in VLC and in the volume control for the
computer. And even that can be a bit too quiet. Is there another way to
increase the volume for these podcasts? I looked at Sounds and Audio Devices
in Control Panel, but nothing seemed obvious.
"Jo-Anne" <Jo-Anne@nowhere.com> wrote in message
> I've taken t...Chart Linking
How can a cell in one workbook be linked to data in another workbook.
try the following:
- open both workbooks
- in the target workbook enter the equatrion sign '='
- now select with your mouse the source cell in the other workbook and
"Kenneth" <firstname.lastname@example.org> schrieb im Newsbeitrag
> How can a cell in one workbook be linked to data in another workbook.
Or copy the source cell, select the target cell, choose Paste Special
from the Ed...Data validation list from another worksheet?
Is it possible that the value list for data validation be populated fro
puneetarora_12's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1840
View this thread: http://www.excelforum.com/showthread.php?threadid=38572
Sure is! Use a named range as described here:
"punee..."external data sources" and "external data ranges"
what is the difference between these?
i have run the vb macro code on http://support.microsoft.com/kb/330383 to
check if i have any external data sources or data ranges but there are none.
the reason i need to know is becuase i'm working with office sharepoint
server 2007 and i cannot access a file thru the web access web part because
"The workbook that you selected cannot be loaded because it contains the
following features that are not supported by Excel Services:
External data ranges (also called query tables)"
..."Freeze panes" settings lost after opening file in two windows
I'm using Excel 2003. I've got a big Excel file with multiple tabs.
Many of them use "freeze panes" to keep headings in place.
I needed to flip back and forth between multiple tabs, so I opened the
file in a second windows. Now, when I save it, all the "freeze pane"
settings are lost.
That Freeze panes setting is assocated with a window.
Maybe you're not looking at the correct window or maybe you closed the window
that had freeze panes applied.
to see if you still have multiple windows assoc...Source data, in Chart Menu, is grey and not accessible.
I set up a pivot table and designed a chart, saved and closed out of the
workbook. Upon returning to work on this project, when selecting the chart
menu to work with my source data, the source data is grey and not accessible.
What might be causing this and can I correct it?
It's a pivot chart. As soon as it's created, it's linked permanently to the
pivot table, and you cannot change the source data. you cannot add more data
that's not in the pivot table to the chart, nor can you remove data that is
in the pivot table from the chart.
Jon Peltier, Microsoft...combination clustered column and stacked bar chart
I have data concerning the repair turn-around for three products over several
months. There are two components to the turn-around time for any item, i.e.,
actual labor time and wait time. I want to graph this as a clustered column,
each cluster representing the data for a given month and each bar in a
cluster representing one of the products. Now for the tricky part: I want
each of the bars to be stacked showing the relationship between the actual
labor time and the wait time.
I don't know if I'm fully understanding what you want. Possibly these two
examples can hel...