bar chart with two axis
I am trying to create a chart that looks something like this:
process1 process2 process3 process4
project a 9/11/2006 10/9/2006 11/6/2006 11/20/2006
project b 9/11/2006 10/9/2006 11/6/2006 11/20/2006
project c 9/15/2006 10/13/200611/10/200611/24/2006
project d 10/30/200611/27/2006 12/25/20061/8/2007
and then on the value (y) axis have dates listed( at half intervals,
1st of the month and 15th of the month) listed
have just each month listed.
basically each project has its own time line, every project has the
some process but at different dates.
i have been spinning my wheels on t...limit range to unique values
I am looking for a way to limit a named range to unique values. So
that if a value is entered that already exists in the range the value
that already exists would become empty and the new location would hold
the unique value.
I got something sort of working with the selection change event but it
took too long to cycle through each cell in the range to make sure it
did not equal the target value. was not pretty. The range is only
like 50 cells.
I am looking for advise on how to make it work.
Include your efforts to date
If desired, send your file to my address be...Sum multiple lookup values
Hopefully someone can help me with this:
I have a spreadsheet giving activity and copst values for medical
procedures and I'm trying to quickly and easily summarise by
department (General Surgery, OBGYN, Trauma & Orthpaedics etc). What I
could do with is a method of looking up the department and summing all
the values in that department.
So I want to lookup the values from Tab1:
Col C Col D Col E Col F Col G
Dept Procedure Code Unit cost Activity
Gen Surgery Surgury1 xxxx =A320 5
Gen Surgery S...Secondary protection of Hyper-V VMs possible?
We have built a secondary DPM server to be able to backup our protection
groups off site.
This is working fine for all but the protected Hyper-V machines on the
primary server. When I select the primary server, I don't get an option to
protect those machines.
Is this a bug, or a known feature limitation of DPM?
Any help would be greatly appreciated!
Probably you're missing some required hyper-v hotfixes, I can back them up
fine from my secondary.
> We have built a secondary DPM server to be able to backup our protection
> g...Payees in Pay To disappearing
I am using Money 2006 Deluxe. It has worked fine until now. All of a sudden
as I am entering a Payee into the Account Register, the payee disappears from
the Pay To drop down list. I have a few payees that have somewhat similar
names, ie: Bank of America, Bank of America Visa, ect. If I input a payment
to Bank of America, it disappears from my dropdown list. When I go to input
a payment to them again, it will only allow me to put in the next Bank of
America setting. I have to tab off, then go back to the pay to box and
delete what I don't want for it to work. This is becoming...Help needed with multi y-axis chart
I have created a combination chart which use bars to show company
financials and a line to show unit sales. During the early part of the
company's history, certain financial values are less than zero, thus
the minimum value for the primary y-axis scale is less than zero.
The problem is this - Excel aligns the minimum values of both y-axis
scales, thus zero units is aligned with negative dollars. This is
confusing to the viewer.
My question is this: Other than manually tweaking the scale for the
number of units sold, is there an automatic means for having zero be
aligned on both sca...Enter Parametr Value
I have the following SQL that selects the TOP 10 clients by percentage of
sales. I want to be able to SELECT the TOP 20, TOP 40, TOP 60, etc.. by
entering a value when the query runs. How might I change my SQL? Any help
SELECT TOP 10 tblPct.ip, tblPct.Pct
ORDER BY tblPct.Pct DESC;
On Fri, 8 Jan 2010 17:52:02 -0800, NEWER USER
The only way to do that is to use dynamic sql.
This will not work:
select top forms!myForm1myControl from myTable
This will not work:
select top [parMyTop] from myTable
(...Disappearing sent email text.
This morning I started losing seemingly random sent email
text. The header appears on the listing, but text area is
It looks like virus activity to me, but a complete scan
with NAV shows nothing, and I can't seem to find
documentation on this behavior.
Am getting somewhat frantic.
...Show image for specific record on report based on yes/no value
We have a product database which has several yes/no categories for
each record, I would like to be able to show an image on the report
based on which yes/no boxes are ticked.
So, we have a list of plants in our database that have yes/no columns
named "Sun", "Shade" or "Semi-Shade" (depending on what aspect they
like) I have a different image for each option (named the same .jpg)
and I would like the relevant image to show up on the report for each
record if it is true, so the report is easier to scan with images
rather than text. Any ideas on how I could do t...position of vertical axis
I have a chart that has the vertical axis labels on the right side of the
page. Is it possible to move it to the left side of the page?
> I have a chart that has the vertical axis labels on the right side of
> page. Is it possible to move it to the left side of the page?Right click on your data and choose axes from the pop up box check
"Primary" and uncheck "Secondary"
'The Code Cage' (http://www.thecodecage.com)
---------------------------------------------------------------------...How to align the category axis to plot area
I'm trying to align my category axis of my chart to the bottom of my plot
area. I have some negative data and it's moving the date (category axis) into
the data of the plot area.
Hope this make sense. Thanks!!
Format the axis and specify where you want it to cross the y-axis.
Bernard V Liengme
remove caps from email
"awrex" <email@example.com> wrote in message
> I'm trying to align my category axis of my chart to the bottom of my plot
> area. I have ...Y axis #4
If I have a chart that i want to switch the left values and scales on the Y
axis with the one on the right is there an easy way to do this?
To swap primary and secondary Y axes, you need to have both primary and
secondary X axes, at least temporarily. Format the scale of each horizontal
axis, checking Value Y Axis Crosses at Maximum for one, unchecking it for
the other. Then if you needed to add it, remove the secondary category axis.
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
I have a database I want to subtotal by both State and City. So for example,
I want to see subtotals for individual towns such Dallas, Houston, Cleveland
and Toledo, but then I want to see totals for Texas and Ohio.
I sorted first by State, then City and created subtotals for the sales
amounts based on the State. All is OK.
I created the secondary subtotal just like the first one except at each
change in City, and I told it not to replace subtotals. It doesn't look
right. Does any of this make sense? Any ideas what I'm doing wrong?
Do it the other way around, Dino. ...money 2004 data file disappears
NTFS file system
My data file disappeared have backup but am concerned about cause.
Ran chkdsk and no errors found.
Any help would be appreciated.
In microsoft.public.money, msnews.microsoft.com wrote:
>NTFS file system
>My data file disappeared have backup but am concerned about cause.
>Ran chkdsk and no errors found.
>Any help would be appreciated.
Make an extra copy of your backup on other media.
Do a Start->Search of your drives for *.mny files.
Cal Learner-- MVP wrote:
> In microsoft.public.money, msnews.microsoft.com wrote:
&...Y axis title cropped
Help. Whenerever I do a title for the Y axis in excel the title gets cropped
off. I tried reinstalling office XP ( Excel 2002, SP3) but that did not
work. Why does my version of excel do this? I can take the same file and
put it on a lab computer create a chart in the same worksheet and then it
works fine. HELP!
...Sum value between dates problem driving me mad!2
Good Evening All,
Many aplogies for the crappy formatting of my previous post, I have done it
properly (I hope) now.
I am really struggling here, have tried, nested IF's including AND's but am
a bit stumped.
I am fairly familiar with Arrays, but cannot seem to combine all.
I have a data table (as detailed below). I simply wish to calculate the
expected totals per month.
Any help & assistance with this would be most welcome.
Note, earliest Start is 01/04/03
Start Finish DayRate Apr-2003
May-2003 Jun-2003 ...Primary and secondary Y-axis with same 0 line
The minimums and maximums of the data shown are likely to be very different;
however I would like them to have the same 0 line. There are positives and
negatives (sometimes only on the primary axis) so my 0 is often not lining
up (i.e. 0 on the primary axis is lower than 0 on the secondary usually).
Is there a way to make sure that the two Y axis share the same 0 line but
with different scales?
Jon Peltier's page on the subject may help.
Peter Hemmingsen wrote:
> The minimums and maximums of the dat...Overlapping time (X) axis labels with auto axis options
I am using Excel 2007. I have created a Scatter chart with straight lines
and markers. My data source consists of 100 rows of evenly spaced data
points (one column for the time the date/time the data points were taken, and
a second column for the actual data points.
While I always have 100 evenly spaced data points, these data points can
span anywhere from just a few minutes to several hours. For this reason, I
have the axis options for my X (time value) axis set to Auto for the Min,
Max, Major Unit, and Minor Unit.
The problem I am having is that when my data only covers a sho...Data in secondary axis dizappears when using names
Hi there, I'm using Excel 2007 and the problem I'm facing is this: I've
created a graph which reads data frrom a simple table. Then I named the rows
in that table using the OFFSET formula as I want to plot only the last 10
entries of the table and not the whole table. The names that I've given are,
for example, row 1 is 'Date', row 2 is 'Asset' and row 3 is 'Liability'.
When I select the name, I can see that it highlights the area that I want to
be plotted (the last 10 entries only). 'Asset' is plotted in the graph using
Primary Ax...Sum specific row values
Hi there, i have a problem trying to sum some values that are in
certain rows...The table looks like
Col1 Col2 Col3 Col4
P X 112 a
P X 100 b
P X 26 c
P X 15 b
P X 13 d
P X 10 a
Ok, the result must be a table that looks like
Col1 Col2 Col3 Col4
P X 122 a
P X 115 b
P X 26 c
P X 13 d
Please help...i need an sql query, if possible...
...mail disappears from all folders when any icon is clicked
When I open Outlook all my mail appears in all folders:
sent/inbox/outbox. After clicking on any icon, all the
mail from all the folders disappears. I also cannot
send. It hangs. If I close the app and reopen, all
folders have mail and the process repeats. Is this a
problem with XP? MSN? I didn't have outlook issues with
other ISPs. Thx,
On sheet 2 column A you are allowed to enter values from a drop down, what I
want to be able to do on sheet 1 is count the number of times each of these
Hope someone can help
Put your list in column A of Sheet1.
Then use a formula like this in B1:
and drag down.
> On sheet 2 column A you are allowed to enter values from a ...Scaling the x-axis
Using a line chart, is it possible to have scaling appart from th
Y-axis to the x-axis, regardless the kategory-values of the x axis?
For example the values of x to establish some points are 5, 15, 30 etc
is it possible to put them on scale as well on the chart?
Thanks for your time!
Message posted from http://www.ExcelForum.com
not quite sure but try using a X/Y scatter chart
>Using a line chart, is it possible to have scaling appart
>Y-axis to the x-axis, regardless the kategory-values of
the x axis?
>For example the values of x to...creating different emails dependant upon a control value
I want to be able to produce two different emails. one with just standard
financial info on (got this working) and one with additional variation info
on (not working)
i need someone to look at the code i have below and highlight where i have
gone wrong and what needs to be done.
i am using Access 2000 and Outlook 2002.
thanks in advance
Private Sub Form_Open(Cancel As Integer)
'Arvin Meyer 03/12/1999
'ammended by Peter Coxsey 28/06/2007
On Error GoTo Error_Handler
Dim objOutlook As Outlook.Application
Dim objEmail As Outlook.MailItem
'Dim objEmailS...assigning value to a column based on a table of values
I am correcting an exam and I have automatically generated the score of the
students. These I have in columns. Further I have a translation code that
showes how a score relates to a grade. this is shown below. Here the interval
from min to max is the score that produce the grade. For example if the score
is between 2 and 5 the grade is 5.
How do I make the translation from score to grade automatically?
min max grade
0 2 3
2 5 5
5 6 6
6 7 7
7 8 8
8 11 9
11 18 10
18 23 11
where E1 holds the score to be graded, B2:C9 holds the max and grade