default appointment times problems
When i re-open outlook and go to the calender, all the appointments times
have changed to 1am on the start day - 1am on the day after it waqs meant to
finish. So a 12 day appointment is now shown as over 2 days.
How do you change the default appointment time settings so an appointment
which is just typed into the day is from 9am - 5pm for example and will stay
as a 1 day event when opening and closing outlook?
All day events are 12 -12, not 9-5. If you want it 9-5, you need to make it
All day appointment change to 1 -1 if you change the time zone or DST
settings aft...Is is me? Or is Excel 2007 Charting Lame?
Maybe I'm missing something. If so, let me know.
The process of creating a chart is unintuitive and cumbersome. A big
step backwards from 2003. The manual says to just select your data
and insert the chart. What I find is that 95% of the time, I have to
re-do the data selection. If I highlight two columns and insert the
graph, Excel thinks both columns are two different series instead of x
and y axis.
I create two columns, label one of them "X", one of them "Y". Put
some numbers below that. Now insert an XY chart. One would think
that it could figure out "...100% Stacked Bar chart, two bars, want percent as well as real value
I am attempting to chart the following:
Series 1 - Values over the prior 30 days
Series 2 - Values over the prior 12 months
I would like to show both data series as 100% bar charts, so users of
the information can compare percentage of the last 30 days with
percentage of the same piece of data over the last 12 months.
So, for example the two data series might look like this:
I want to display both the actual value, and the percentage of the
total, for each series, in the labels. For some reason, showing
percentage is not an option. Why is th...Numbers Chart
I need a 10x10 chart of numbers 1-100 with the numbers vertical.
I'm sure there is a quickie way to do it.
C and A Bredt
Top left corner of chart:
Copy to a 10x10 area.
*Remember to click "yes" if this post helped you!*
"C and A Bredt" wrote:
> I need a 10x10 chart of numbers 1-100 with the numbers vertical.
> I'm sure there is a quickie way to do it.
> thanks, CB
> C and A Bredt
Highlight the cells, format > Cells > Alignment and make it 90 degrees.
"Luke...Text Boxes added to Chart Series
How do I keep text boxes that I've added to a data series with the column
they belong on? If I change the size of the chart in anyway, I have to move
the text boxes back to their respective spots on the chart.
Text boxes are not added to a series, but to the chart. This prevents their
sticking to any particular points. Could you add them as data labels? If you
use a built-in position (i.e., don't drag them around) they will stick with
their associated points
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://P...multiple outlets centralized Inventory needs POS solution
One of our customer has multiple outlets. Selling is conducted through the
outlets. they have a centralized warehouse. A POS solution is required
Contact your local RMS dealer he can help. Store ops in each location then
HQ in warehouse.
"Haresh_ahuja" <Haresh_ahuja@discussions.microsoft.com> wrote in message
> One of our customer has multiple outlets. Selling is conducted through the
> outlets. they have a centralized warehouse. A POS solution is required
You need a HQ for the warehouse and store op...Pivot table and it's macro
I am creating a table and from the table a pivot table using a macro. When I
run the macro the table gets created without a problem but when it goes to
create the pivot table I get an error and the debugger highlights this
ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
:="Perf Tables!R2C8", TableName:="PivotTable1", DefaultVersion:= _
Can anyone see where the problem is happening?
My ...multiple or conditions
I have written syntax that doesn't seem to be picking up all my or conditions
thus leaving me with an inaccurate answer. What am I doing wrong?
Look in HELP index for the proper syntax for OR
"lschuh" <email@example.com> wrote in message
> I have written syntax ...Pivot Table % of
I have a pivot table like the followng:
Joe Trans Ct
Total Joe 10
Total Kelly 11
I added another Count of Trans shown as a "% of column", but it gives me the
percent of the entire column when what I really want is the % of Total Joe, %
of Total Kelly, etc. In this instance I simply made the names go across
instead of down which solved the problem, but there are instances where I
don't want to do that. Any suggestions for getting the percent per item
rather than pe...Pivot Table Updates Issue
My Data had a coloum containing stuff like
I built a bunch of pivot tables on this data. Then I changed the data
and performed a Refresh Data.
Now, on the filter pulldowns on any of the Pivot tables, I see
The first three option no longer exist in any of the data, and I do not
want them in the list. How to fix this problem without recreating and
reformatting 38 seperate Pivot table...Pivot table row header
In a pivot table, I have 2 fields in the row section.
How can I have the value on the first fields to repeat in every row instead
of just showing once?
Try Debra Dalgleish's page at:
Fill Blank Cells
Fill Blank Cells Programmatically*
'by Dave Peterson 2004-01-06]
GMT+8, 1� 22' N 103� 45' E
"Jason" <Jason@discussions.microsoft.com> wrote in message
news:08549CBC-68A7-442E-BABF-D48B11E29479@microsoft.co...create pivot table formula without the GETPIVOTDATA function
Previous to Excel 2003 I could use a pivot table result in a formula and copy
that formula as a relative reference. In Excel 2003 a GETPIVOTDATA fromula
is created and uses an absolute reference. Is there a way in Excel 2003 to
either make it arelative reference (without editing the formula) or revert to
the method used in all prior releases?
There are instructions here for adding the Generate GetPivotData button
to a toolbar, and toggling the feature on and off:
> Previous to Excel 2003 I could use a pivot table resu...time calculation
I need to do a check on the time.. if it is after midnight but before 5am
then I need to minus 1 day off of the date. How could I do this?
If the Date and Time is in cell A1, use
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***
...shortened versions would be
=A1+AND(MOD(A1,1)>VALUE("12:00 AM"),MOD(A1,1)<VALUE("05:00 AM"))
** Posted via: http://www.ozgrid...in what order should i place multiple brochure pages?
i am wondering in what order should i lay out my pages in my brochure so it
will print correctly . . .
I would use one of the brochure templates, create, print it out and edit to
"critic" <firstname.lastname@example.org> wrote in message
>i am wondering in what order should i lay out my pages in my brochure so it
> will print correctly . . .
...RMS should allow you to choose more than one item at a time
RMS should allow you to choose more than one item at a time, this would be
helpful in creating PO's. Mutiple item selection is a standard in every
software; you really dropped the ball with this one.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.micr...Can multiple cell results be displayed in a single cell?
Is it possible to display the contents of multiple separate cells in another
If the results of several cells say B1, B2, and B3 are the amounts $10, $15
and $20, I would like to display them in cell A1 as follows:
I could do this statically by using text and the 'Alt|Enter' function within
the cell. However, these amounts will change from time to time so I'd like a
Is this possible or not?
Thanks for any help.
="$"&B1&CHAR(10)&"$"&B2&CHAR(10)&"$"&B3&am...Importing vcalendar data to multiple users
I'm running Exchange 5.5. Several times a year I have to create a large
group of users. I'd like to be able to pre-populate each user's
calendar with pertinent calendar events.
Is there a way to import this type of data in batch mode?
See if http://www.slipstick.com/calendar/holidays.htm#company helps.
> I'm running Exchange 5.5. Several times a year I have to create a
> large group of users. I'd like to be able to pre-populate each user's
> calendar with pertinent calendar events.
> Is there a way to import this type of data in batch...Worksheet Change Event log for multiple cells
I have a spreadsheet that is available here:
(although I scanned it for viruses please make sure you do it again prior to
opening it as I cannot guarantee it's worm free).
I would like to create a log file in an additional sheet (hidden probably)
that would record every activity from column E after clicking a button
assigned to a cell in that column and show these records in a worksheet
Totals in a specific row.
For example: Column A from a worksheet „Totals” corresponds with column A in ...How do I freeze a chart from scrolling
I want to freeze a chart so as I scroll through data it will not go up or
down, I dont want it to be frozen in a horizontal position. Is there a way
this can be done?
You would need to freeze a number of rows at the top of the sheet and
place the chart there.
Or use New Window to create a copy of the worksheet. One would display
the chart then other would be used to scroll through the data.
> I want to freeze a chart so as I scroll through data it will not go up or
> down, I dont want it to be frozen in a horizontal position. Is there a way
>...How move multiplicity labels in UML diagrams?
How can you move the multiplicity labels on lines in UML diagrams? Also, is
it possible to move the name labels?
...Pivot Table: showing data as % of subtotal
I have pivot table data in this format:
Name Type Amount
ABC 1 $100
ABC Total $1,000
DEF 1 $150
DEF Total $1,140
and so on
I want to see the data as follows:
Name Type Amount %
ABC...Side bar chart chinging size
I'm trying to update a side bar chart but every time I open the chart the
size of the chart changes in length. Can anyone help me to correct this
problem. I have made sure that I sized the chart to 100%, clicked off the
auto scale, but nothing has helped.
...Publisher should allow the deletion of multiple pages
I wish publisher would allow for the deletion of muliple pages much like the
options available when printing pages.
lejianzhong <email@example.com> was very recently
heard to utter:
> I wish publisher would allow for the deletion of muliple pages much
> like the options available when printing pages.
Suggestion: Try here:
How to Contact the Microsoft Wish Program
Ed Bennett - MVP Microsoft Publisher
...How to open multiple cases
Does anyone know if there's a way to open a case for several companies at one
time? I've got a situation where I need to deploy a service bullitin for
serveral companies. The title, description, etc.. are all the same.
Hmmm. Do you really need to open cases at first? If it's just a bulletin,
then maybe you create a campaign to notify the appropriate customers, and
then track the responses against the campaign.
Microsoft Certified Professional - Dynamics CRM
> Does anyone know if there's a way to open a ca...Hiding or Displaying Series In a Chart
I have a XY Line chart that contains 9 Series, ploted at the same time. Due
to visual clutter in this chart, I would like to have the option to enable or
disable these lines by using a check box for each of the series.
Is this possible? and how can this be done programatically?.
Thank you in advance for your prompt response.
Jon Peltier has instructions for using a check box to hide/show a series:
> I have a XY Line chart that contains 9 Series, ploted at the same time. Due
> to visual clutter ...