Data Series Labels in Area Chart
I'm trying to create a combination chart; one data series in an area chart,
and three in line format. Got the chart created, but the data series labels
for the area chart show up in the middle of the area, which looks awkward.
Is there anyway to move them closer to the top edge of the area plot? I
don't seem to find any options for moving the labels in an area chart.
The data labels for the area series have no options for alignment.
Add another line series to the chart based on the area data. This has
the options to align data labels. You can format the line seri...Copy Pivot Chart
Does anyone know how to copy a pivot chart and paste only its values?
You can copy/paste special/value as you would any other cell values. However,
you need to navigate from "edit" on the tool bar. These options are not
available for a pivot table via the right click.
> Does anyone know how to copy a pivot chart and paste only its values?
...Retrieving Data from a Column / Row to populate a cell
I currently have data supplied to me in an Excel spreadsheet that I to
I would like this to populate a cell reference, the problem I have is that I
cannot gather a train of thought to obtain the data from from a specific
There is a sample of the data supplied to me below
Name In Out Int
Greg 165 108 29
09 July 2003 42 34 9
14 July 2003 44 19 4
16 July 2003 40 40 8
17 July 2003 39 15 8
Andrew 125 43 9
1...The data in my form is changing after the status is closed
I have a form which is based on a query for invoicing. I have some
client who have been invoiced for their service and not their status
is closed. If this person returns as a client and I set the new
contract year and I go to the invoicing form to invoice for their new
serivce the prior year contract year information for the service which
has already been closed is no longer there. I want to keep this data
as read only, but still be able to add new information.
...How do I add a data series in a combination chart in PPT 2003?
I have a combination bar/line chart showing gross revenues and passengers by
month over a 3-year period. The gross revenues are bars on the primary
y-axis and passengers are lines on the secondary y-axis.
I am trying to add gross revenues and passengers for CY2010. I am able to
add a data series for the passengers, but when I try to add a data series for
the gross revenues, the chart treats it as a series on the secondary axis as
How do I add the series as a bar on the primary axis, or alternatively,
change the series from a line on the secondary axis to a bar on th...Multiple Vlookups
Currently i have a large list of insurance sales agents & have t
record their sales on a daily basis.
I have a spreadsheet for each week with a total at the end & also hav
a monthly sheet vlookuping each total of each week
Is there anyway i can reduce the large vlookup formula that i
=vlookup(x,wk1,1)+vlookup(x,wk2,1) etc etc. I also have each week o
day references to a list of sales agents as this can change daily
which requires me to open up each weeks spreadsheet or the monthly on
doesnt update correctly
please help as each files is around 1mb n very slow
mi...How can I change which cell is selected next, other than Down, Le.
I know there should be a simple answer to this question, but I can't find it
on the "Help" menu.
tools / options / edit
"move selection after enter"
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Bethany" <Bethany@discussions.microsoft.com> wrote in message
>I know there should be a simple answer to this question, but I can't find
> on the "Help" menu.
and select one of...Adding SMTP addresses to multiple users
Is there a way to add a new smtp address to a group of existing users (2000+)
in an Exchange Organization / Active Directory Domain?
Why not create a Recipient Policy?
Alternatively, check out admodify.net.
MVP - Exchange
NEW blog location:
"bj" <email@example.com> wrote in message
> Is there a...Saving a record on a form to multiple places
Here is what I think will be an easy question, but im not sure...
Lets say I have a databasee, which i do. Lets say that on my main
form, I have a text box called "company". On the same form, I have
command buttons that link to other forms that have to do with this
company, but they are too numerous to put all on subforms within this
form, as I was instructed to make the forms less cluttered.
When I enter a new company's name in the text box, as if im adding it
for the first time, I would like it to update that field to other
tables as well, which all contain that companies n...repeating custom headers on multiple pages
I apologize in advance for such a stupid question but i have searched every help file and cant find any mention
I have a workbook with 5 sheets and i want the same custom heading to print on each sheet
I tried selecting all sheets going into print preview and adding the header but it only prints on the first page
my brain refuses to believe that i actually have to go to each sheet and retype the header and footer
please tell me i am wrong and also how i can accomplish this task
Using Headers and Footers should repeat the header on every page. Care to contact me and discuss i...Selecting the font size matching the control's height
I have an array of labels, which height changes in relation to
the form's height (form is resizable).
What will be the best method of selecting the labels caption font size?
On 7 Feb, 04:46, "Claire" <replyto@fra> wrote:
> =A0 =A0 =A0 =A0 =A0 =A0 I have an array of labels, which height changes i=
n relation to
> the form's height (form is resizable).
> What will be the best method of selecting the labels caption font size?
Might be an answer here http://www.dreamincode...Org Charts
I have 5 people that report to the same person and currently they all show on
the same row, the owner of the company wants the 3 VPs to show directly
underneath him but the remaining two to have their line drop down lower than
the 3 VP's. IS there a way to do this? Everytime I try it just makes the
box bigger for all of them.
Are you doing this in Excel? Which version? Which tool the Diagram tool or
the AutoShapes tools?
> I have 5 people that report to the same person and currently they all show on
> the sam...formatting or moving a radar chart's axis labels
I am attempting to change the orientation of a radar chart's axis
labels. Its orientation seems locked in place immediately to the left
of the 360=B0 gridline. I would like the ability to display the axis
labels directly over the range rings and along other gridlines, such
as 180=B0 or 270=B0.
With other charts, the formatting option allows one to select "high",
"low", or "next to axis" to change the position of the axis. This
maneuver seems to have no affect whatsoever on a radar chart.
As a final resort, I suppose I could turn the axis labels off...finder search across multiple xls for one term
I have about 400 spreadsheets nested in various folders on a single
Trying to find a long forgotten spreadsheet, which I can only identify
by a value it contains. Let's say it's 114,167.18
I've used OSX 10.6.2 finder search with 'contains' and at first it
When I lose the comma, ie 114167.18, several .xlsx spreadsheets appear
as containing that value. Great!
Trouble is, I need the original spreadsheet with that value and it's
an older document, listed .xls as opposed to .xlsx
It seems OSX 10.6.2 finder cannot look inside .x...Multi choice list box and two ALL selection
Hello. I have a pop-up form that has 2 list boxes. I want to do 3
On the list boxes, I want to make them multi-choice list boxes.
Second, I want to make a selection of "all" for both list boxes. And
last, I would like to have the text boxes default to the all
selection, if possible, until another selection is made.
The list boxes are:
They are populated by tables - Automobiles - Car Table and Automobiles
- Action Taken Table, respectively.
Finally, they run through query called AutomobileSearch.
Thanks for the help.
To make your list multi-select, ...Naming a chart object
When charts are created they are named "chart 1", "chart 2", and so on
I need to name a chart in order to update it from vba, but when
select the chart I cannot click in the name box? Help
Message posted from http://www.ExcelForum.com
To rename a chart, hold the shift key down and select the chart.
This selects the chart object instead of the chart area. You can
then rename as usual.
Thanks Ed, so simple when you know how.
Message posted from http://www.ExcelForum.com/
...merged cells and creating charts
I have tried to create a chart with data that is in merged cells where I have
put in a formula to calculate the average of 4 cells in the row above. When I
create the chart, it recognizes all 4 of the merged cells. So the graph has 4
spaces for the data for each number I am trying to plot. I just got 2007
version and do not recall this problem at all in 2003 version
Merged cells are to be avoided at all costs.
They can be used for column heading but for little else.
Bernard V Liengme
Microsoft Excel MVP
remove caps from email
"Troubled...Chart disappears in Excel 2000 after scale is changed
When the scale of the chart is changed, the chart disappears. The chart
and its data are on the same worksheet.
...Multiple Combo box in a form
i'm have a form. i want to do three combo box. one is customer, one is partID
and one is process. this three combo box are from three different table.
there are customer table, part master table and process table. i want to do
like this. if i choose one of the customer from the combo box, then when i go
to the partID combo box, then i want it just show out whatever the part which
belong to that customer only. others customer's part wont be in the list.
then when i click on the process combo box, then i just want the combo box
show out the process which is belong to that partID w...Prevent cells with no value from being plotted on chart
I have a chart based on cells that are the result of a
calculation. The cells show empty if the data used for
the calculation is not yet available (future data). As a
result, as my chart shows the whole year, the line drops
and remains to zero after the last available set of data.
Excel will let me prevent an empty cell of being plotted
but since there is a fornmula is the cell, it is not
considered empty, and therefore displayed.
How can I prevent these cells to be plotted on the chart?
You can use an IF formula with NA(). For example:
I have to come up with an OT schedule but I want it to be done randomly,
but at the same time it has to be based upon people's availability.
For instance, I have 9 people and each person has their own
availability for the week. (see the data below) If I put these people
in a range based upon their availability is there a way that I could
put their OT coverage in randomly for each week, knowing that I have to
have at least 3 people a night? Is there a way, or is there a formula
that would be sufficient. I hope that made sense.
Mon Tue Wed Thur Fri Sat Sun
DC EA KS KS JK CL JA
PH ...Adding Lines Onto Charts #2
Thanks for the reply,
Unfortunatley, this technique wont work with the way I have the graph
It wipes out the layout of the bottom axis.
Does anyone have any other idea's please?
Thanks in advance
q582gmzhi's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1136
View this thread: http://www.excelforum.com/showthread.php?threadid=26950
You can use an additional data series with error bars to draw the dividers.
Using you example workbook put t...Logarithmic charts
How should the data be entered in a logarithmic chart. I want the log data
entries to be on the left and the other data to be displyed on the bottom.
My chart will give a logarithmic resistance vs RH. I have tried to list the
data by columns left to right first the resistance then thRH for 4 different
series. It just doesn,t look right and I cannot change anything easily. Are
there any sources for making charts in excel ,especialy Logarithmic ones?
Thanks for any help?
In A1:A10 enter your resistance values (the x-values)
In B2:B10 enter the RH (meaning?) values (the y-values)
I have a tricky chart I want to make. So far it looks
okay, but I have a problem that I hope is fixable.
I have 5 data series that I want to represent in a graph
with 2 axis.
I want to use the stacked column type of graph putting 2
series each in one column. ie series = Actuals1, Actuals2,
Budget1, Budget2, Last years totals.
I want 1 stack showing Actuals1 & Actuals2 together,
another showing Budget1 & Budget2 together and a line
showing last years totals(I'd prefer another seperate bar
for this on it's own, but can figure out how to do this).
So far I have got...How do I clear the formating of the area OUTSIDE my chart on my w.