excel charts #14
i have a chart set up to chart data calculated from a formula, if no data is
entered into the formula the chart plots that perticlar date as zero. How do
set it up so nothing is plotted unless a value has been input?
configure the formual so that blanks are enterd as #N/A
"matsuda" <firstname.lastname@example.org> wrote in message
> i have a chart set up to chart data calculated from a formula, if no data
> entered into the formula the chart plots that perticlar date as zero. How
> set...Track Changes 03-12-10
Let's say I have added 10 words using track changes and then saved my
document. Now I want to delete 2 of those words, instead of just deleting
them it puts the strikethrough in those 2 words. Why and how do I stop it?
This doesn't happen to all documents.
Right-click the words and select Accept Change (or Accept Deletion) from the
Microsoft Word MVP
"Flasho" <Flasho@discussions.microsoft.com> wrote in message
> Let's say I have added 10 words usin...Change to Insert Drop Down Menu Items Office 2003 Win Vista Home P
When I click Insert>Auto Text>Signature in Word 32003, all of a sudden,
beside many of the choices with an > I'm seeing the message Sign Into Office
Live Workspace Beta. As I said, it's beside quite a few of the choices in
this drop down list. If I click it, it does nothing. I did nothing to change
this. Have I gotten an Update from Microsoft that changed something?
Now why would Microsoft release an update that screws up Word Pro 2003. Are
we pushing 2007 or 2010?
Any answers to help restore this function to its working status is greatle
I alrea...Creating a Pivot Chart
I am sure there is a pretty simple trick to this that I just cannot figure
out. I would like to put these currencies into a pivot table and be able to
filter by Country. My ideal situation would be able to set up a Pivot graph
that I could pick and choose which currency I wanted to show using the report
filter. Everytime I try I cannot get this result. My sheet is set up as the
Colums have the Country Currency Ticker USD, JPY, GBP, etc with the values
beneath them. The rows are labeled by date starting at 1/1/2006 to 10/22/08
starting in cell. The column labels start ...Help with hierarchy in organization charts
I am trying to create a basic org chart for my organization. I am having difficulty representing people at different levels that report to the same person. For example, a manager and a director might report to a partner. I want the manager to appear lower on the chart than the director, but want a direct line to the partner above both people. I realize I can manually lower the manager, but when I use the re-layout function the manager is elevated back to the level of the director. Any ideas? This was easy to accomplish in OrgPlus and I assume there must be a way in Visio as well. Thanks!...Map projection as an Excel chart
Can I download Excel chart based on a map projection?
...column chart changes my data
Hi I have attempted to make a column chart with error bars using
as my data, BUT when i highlight and insert chart my figures (6.3,6.8,7.5)
change to 1,2, and 3. and my other figures change to 1-8
I am trying to show rate of reaction vs pH level
can anyone tell me what i am doing wrong as I dont normally have any trouble
with these charts.I am using office 2003
thanks to all
You should be using an XY chart for numerical value, particularly for
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Pelt...Log-log charts #2
I'm using Excel 2002 and am trying to create a simple log-log plot. Making
the y-axis logarithmic is easy - it's a check-box option under Scale tab of
the Format Axis dialog. But for the X axis the dialog does not have that
option. My XY data is valid (all positive values). There's web sites that
say you can do this (e.g.
http://cstl-cst.semo.edu/venezian/Utilities/graphs.htm). Why doesn't my
Excel support it???
Any help is appreciated.
Sounds like your chart maybe a line chart (x-axis is category) instead
of true xy scatter.
Right click the chart...Keep conditional format when "show pages" from Pivot table
When I use "show pages" to drill down the data into pages from Pivot table, I
find the conditional format on pivot table is missing. I have to make
conditional format again to every page.
How to keep the conditional formatting when I use "show pages" from pivot
Maybe you could just apply Data|filter|autofilter to your original data range
and filter to show what you need to see.
> When I use "show pages" to drill down the data into pages from Pivot table, I
> find the conditional format on pivot table is missing. I have to m...How do I put a chart into a new sheet?
The version of excel I usually use has a prompt to put the chart into a new
sheet, where you don't see the spreadsheet anymore. Does anyone know how to
If you right click the chart (near the outer edge0 there is an option location.
> The version of excel I usually use has a prompt to put the chart into a new
> sheet, where you don't see the spreadsheet anymore. Does anyone know how to
> do that?W
...ht change default directory for import/export
In Access 2007 is there a way to change the default folder location used for
import and export? There's a "Default database folder" under the "Popular"
Access options, but it only affects open/save and importing/exporting Access
files (accdb and mdb). All the other import/exports (txt, xlsx, xml, etc.)
all default to My Documents.
Would love to change that, any help?
...Variables in Chart titles?
Is it possible to include a variable/cell link in the title of a chart?
My client is wanting the current date in each report run to show up in
the chart title, and doing it by hand each time is a pain.
Put the formula that builds the desired title text into a cell, then select
the text element (it works for chart title, axis titles, data labels, and
shapes), click in the formula bar and type =, then click on the cell. The
formula bar should now look something like:
but with the appropriate sheet and cell address.
Jon Peltier, Microsoft Excel MVP
Tutorials an...How do I change the booking window?
I am trying to enter a recurring meeting beyond 1 year and it declines saying
"I've gone beyond the booking window," which seems to be 1 year from the
start date. Is there anyway to change this to 2 years or anything beyond 1
Thanks for any help.
The admin needs to change it on the server. See
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
Outlook Tips by email:
I would like to move the ordernumber middle part to a larger number to match
the next available number in the existing paper order system.
Where do I find the row/column in the database to change the seed or next
...Inbox unread total does not change
I have a problem with one Outlook installation in my
office. The number on the right of the Inbox, which should
reflect the number of unread messages, is the total of all
the messages in the Inbox - both unread and read.
How do I fix this?
>I have a problem with one Outlook installation in my
>office. The number on the right of the Inbox, which
>reflect the number of unread messages, is the total of
>the messages in the Inbox - both unread and read.
>How do I fix this?
>What version of Outlook are you running?
...subform used for changing mainform record
Hello. I have a main form that has a tabcontrol on it. One of the tabs has
a subform on it that will list the many of the mainform's one. This is a
parent/child hierarchy set up. So the parents and children are all in one
table. A parent can also be a child and a child can also be a parent.
Anyway, below is the code that I originally used for making the change. Now
it does not and I do not see why. The button that I am using is inside the
subform that when used takes and changes the mainform to the selected record
and the subform as well. The txtChangeRequestID is the...Excel should let me organize charts in groups
When creating many charts in an excel sheet there is a need to organize them
in a way to be easily dealt with.
The proposal is to group those charts in a group cascaded after each other,
each chart has a tap like the taps of the excel sheet which contain the name
of the sheet.
This group of charts may be minimized as an icon which can be dragged or cut
& past in other excel sheet or any other office document.
Also we need the ability format the group in one step instead of applying
the format to each chart.
This post is a suggestion for Microsoft, and Microsoft resp...How do I make x-axis dates in area chart not start from/drop to ze
When I create an area chart from with a date range as the x-axis, there are
diagonals that take the chart to the data value for the first day, and from
the last data value down to the axis. What I would prefer are verticals as
the diagonals sure make it look like the chart has ended with a 0 y-axis
value, or starts with a 0 y-axis value. Any ideas?
Select the x-axis, and format. Adjust the scale to bring the chart into the
boundaries you want. Note that you'll need to enter a serial number
representing the date you want.
*Remember to click "yes" i...How do I track changes made to an Excel spreadsheet within a Word.
I established an Excel spreadsheet within a Word document by just using the
Excel icon in Word and creating the spreadsheet. Now I find that the tracking
feature in Word will not track the changes made to this spreadsheet, nor will
the tracking tool in Excel. Can anyone help?
..."Difference From" custom calculation in Pivot tables
I have been unsuccessful in using the "Difference From"
custom calculation in Pivot tables. When I use this
custom calculation (I can successfully use the % of Total
for example) I get #N/A. Also, I'm not sure what the Base
Field and Base Item boxes represent. I notice in the Base
Item box there is "Previous", "Next" and a series of
numbers which I don't understand what they represent. If
someone could straighten my out on how to use this feature
or point me in the direction of some instructions that
would take me thru this process I would rea...need a refresher: text boxes on charts that use relational formulas?
I could have sworn that a long time ago, I set up one or more text boxes on
a graph that had formulas in them, so the text that was showing would
automatically change each month.
I'm now using Win2000/XL2003, and not having much luck- I want to put my
legend on the bottom, then a text box under it where I will show 3 values
(one for each legend item) to provide some additional information on the
graph. I have too many graphs to do this and have to update it all manually.
What is the best approach to use, to link the contents of my text box (or
similar) to the contents of a cell that on m...Pivot Table Calculated Item #3
I am querying an external database to retrun a pivot table, then i am adding
a calculated field that calculates Regular hours * Bill rate. to come up
with total revenue. When it runs, the calculated amounts are 2, 3, 4 times
more that what it should be.
any ideas how i can get this calculation to return the right amounts.
Excel stores hours as fractions of a day, so multiply Hours * 24 * Bill Rate
> I am querying an external database to retrun a pivot table, then i am adding
> a calculated field that calculates Regular...XL2000: Charts don't print as displayed
Charts formatted and displayed [normal view] in 20% increments, but prints
and print previews in 50% increments. Please help!
Double click on the axis that keeps changing, and on the scale tab,
clear the Auto checkboxes for the scale parameters.
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
> Charts formatted and displayed [normal view] in 20% increments, but prints
> and print previews in 50% increments. Please help!
...IIf statement to change font to Bold
Access 2000. I have a report that shows [Bond], [Credits], [Debits] and
[Balance]. The underlying query for [Blance] is =[Credits]-[Debits]. What
I would like is for the fonts in the textbox [Balance] to change to BOLD
when [Balance] exceeds the amount of the textbox [Bond]
Example: [Bond] shows $1000.00, the [Balance] shows $1200.00. in this
case the balance should be in bold font, otherwise it will be normal font.
Is this possible? Thanks, Randy.
>Access 2000. I have a report that shows [Bond], [Credits], [Debits] and
>[Balance]. The underlying ...Pasted Pivot Table looks at old sheet
i have a quick question about pivot table pasting. i have a workbook where i
am copying the sheet and making a new version for the next month. each time i
do the pivot table on the new month sheet is looking at the old month sheet.
the pivot table is on the same sheet where the data is that it looks at so
each time i copy i want the new sheet to be totaly autonomous from the last
why does the pivot table not update to look at the new sheet?
Copying a Pivot Table will just make the PT use the same source data for
it's Pivot Cache