Is there a limit to the number of slices in an Excel 2000 pie chart. I can
only get (9) to work using the wizard. As soon as I add (10) the last one
gives an error readin and it sits there incomplete.
There are limits but it's not 10.
What data do you have in those 10 cells?
> Is there a limit to the number of slices in an Excel 2000 pie chart. I can
> only get (9) to work using the wizard. As soon as I add (10) the last one
> gives an error readin and it sits there incomplete.
Andy Pope, Microsoft MVP - Excel
I a...selective import data from SO to HQ
Can i selectively import data(customer, cashier, etc.) from SO to HQ and
export it out to other new stores? Thanks.
- The customer data is brought to HQ automatically through Worksheet 401. So
answer is NO you cannot be selective about this.
- Cashiers are not global setting [unless you use RR HQ Misc that allows you
to have global cashier and send messages from to store].
Afshin Alikhani - [firstname.lastname@example.org]
CEO - Retail Realm
> Can i selectively import data(customer, cashier, etc.) from SO to HQ and
> expo...Import from Outlook Express #2
As I switch from Outlook Express to Outlook how can I
import my e-mails without losing the original received
In OE - go to File-Export.
"Richard" <email@example.com> wrote in message
> As I switch from Outlook Express to Outlook how can I
> import my e-mails without losing the original received
...can msn email msgs be imported to outlook? thanks
can msn email msgs be imported to outlook? thanks
This is a multi-part message in MIME format.
There was a feature but I don't believe future versions of Outlook will =
support it. I would transition to a pop or imap account as your mail =
email. There are services that will retrieve your MSN mail and redirect =
it to your other email account. =20
e-Commerce unveiled The e-book
"r...Changing chart background color in Excel 97 SR 2
I am fairly new to this so please bear with me.
I have a chart based on numbers in a spread that has a grey background (The chart) but I
would like the background to be white and can not get it to change.
I right clicked on the chart and went to Format Chart Area, Patterns, Fill Effects,
Patterns and changed the background to white but the ok button is greyed out.
Am using Excel (Office) 97 SR 2
Right click (or double click) on the gray region, which is the Plot Area.
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tut...Combo Boxes in Charts
I have created a chart which includes a combo box which refers to a list
of names. The problem is that the font size is too small - size 10 - and
I would like to make it bigger. Have tried changing the font size of the
data range for the combo box but this has no effect. The properties of
the combo box let me change its size but not the font size of the list
Shirley Munro's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=83...Background picture behind chart
In Excel I have successfully inserted a picture behind an interactive chart
so the chart (graph) is visible overtop of the picture. But when I Save as
Web Page the picture doesn't show up. The graph is fine, and is interactive,
but the background picture file (gif) has disappeared. How can I preserve
the picture so it will save as part of the Web Page? Thanks.
Not tested but could you use the picture as the Fill Special for the
chart or plot area?
> In Excel I have successfully inserted a picture behind an interactive chart
> so the...Automate text import
I've wrtten a batch file to audit all our servers, what
I'd now like to do though is come up with a way excel can
load these text files into one worksheet.
Can anyone please help?
Below is an example of the data gathered - the text files
are named after the computer.
Kernel version: Microsoft Windows 2000,
Product type: Professional
Service pack: 3
IE version: 5.0100
System root: C:\WINNT
Processor speed...importing data from the query wizard
i have tried to import the data using the query wizard but all i get is
SYNTAX ERROR in FROM CLAUSE. Im not doing this using visual basic so i have
no idea how to correct this error. Can anyone help please?
...Can I import a calendar from a palm os to outlook?
"kyle" <firstname.lastname@example.org> wrote in message
When you post in here, always include your version, SP level, and mode (if
applicable) of Outlook - you can find this information in Help | About. Also
include the type of mail account(s) you use and any other pertinent details.
Be sure to put a consise summary of your question in the subject line, and
the full details in the body of your post.
That said, your best bet is just to sync your Palm to Outlook directly. If
your Palm CD didn't...All formatting not saving in Chart Template 04-07-10
Hi, sorry if this has been answered. I am new to Chart templates. I created
a pivot chart and saved it as a template. When I bring it back up again, not
all of the formatting is saved. For example, the title is just "Title" and I
had data values being shown and they are not, and also the colors of the
columns are not the same. Is there any way to save all of these as part of a
...Import data from FileMaker
I have a School Suspension file that is in FilemakerPro. It works very
well. I want to automate a monthly report for our business office and want
to be able to import data from the db into Excel. On Mac's I can do so
quite nicely, simply Open Excel, then Open the FMPro db which launches a
wizard and all is done in a few key strokes. Obviously I'm not as adept in
XP. Using Excel 2003 and FileMaker Pro 6.ov4 how can I accomplish this
I don't speak FileMakerPro, so you can try this or wait for a real response!
Look at all the fileformats that excel ...Legend in charts
how do i change the legends in multiple charts to read the same thing?
In what way?
The legend reflects what is in each chart, so if your charts are different,
so will your legends be. Or are you referring to the formatting?
> how do i change the legends in multiple charts to read the same thing?
...Auto Scaling Charts
I am trying (in Vain) to auto scale bar charts in excel. I have attempted a
macro in VB to do this, but it just seems to do nothing, does not fail or
succeeds. If anyone could take a look at the macro below and assist in where
it is going wrong would be much appreciated.
Dim ws As Worksheet
Dim cht As ChartObject
Dim ValuesArray(), SeriesValues As Variant
Dim Ctr As Integer, TotCtr As Integer
For Each ws In ThisWorkbook.Worksheets
For Each cht In ws.ChartObjects
For Each X In cht.Chart.SeriesCollection
SeriesValues = X.Values
...Trying To Add a Line to an Excel chart using variable cell values
I'm using an XY Scatter chart and I want to draw a
straight line between 2 points which passes through a 3rd
point on the chart. The line represents the Security
Market Line (relating risk and return) with Standard
Deviation on the X axis and Portfolio Return Percentage on
the Y axis. One point is the 3 Month TBill. The point that
the line is passing through is an index point (e.g. S&P
500) and the 3rd point will be one that is calculated
based on the slope of relationship between the TBill point
and the index point. The 3rd point needs to be plotted on
either the top or bott...How to print 15 embeded charts on two sheets at once?
How to print 15 embedded charts (without data cells) on two sheets at once?
You don't want data cells. Does that mean you want each chart printed on its
own page? This cannot be done without a macro. Do you instead want just the
portion of the worksheet with the charts to be printed, but not the portion
of the sheet with the data? Select the range containing the charts, and set
the print area (File menu > Print Area > Set Print Area. Repeat for the
other worksheet, then select both (click on one, ctrl+click on...Autoscaling on XY chart
Is VBA the only solution to autoscale axis in an XY plot...? I would like to
set the min and max for my x-axis as my data changes. (I know how to do it
Or is there any other short-cut?
Office 2003 & Windows XP
Unfortunately you can not link the min/max of the scale to cells
directly. I think VBA is the only approach to dynamic updating of those
Mangesh Yadav wrote:
> Is VBA the only solution to autoscale axis in an XY plot...? I would like to
> set the min ...i can't see a chart i made, all i get is blue worksheet
when i make a chart, it will appear in worksheet with original data. when i
move to its own chart worksheet, all I get is a blue window. What am i doing
Are you selecting the chart and then moving it choosing the command Chart,
> when i make a chart, it will appear in worksheet with original data. when i
> move to its own chart worksheet, all I get is a blue window. What am i doing
...Badly need help to put four categories in one pie chart
The problem is getting the 4 groups on the same Pie Graph I don't kno
how to go about it.
I am taking a correspondence course, the course is MEL4E-A Key questio
8 for anyone that maybe has did this course
Here is the scenario-
The Table below lists baseball team standings. Create a frequency tabl
and a pie graph of the teams that have 80 or more wins, 70-79 wins
60-69 wins, and fewer than 60 wins.
New York 83 53
Boston 79 58
Toronto 68 69
Baltimore 61 75
Tampa Bay 53 82
Chicago 73 64
Kansas City 70 65
Minnesota 71 66
Cleveland 62 76
Detroit 34 102
Oakland 82 55
Seatt...Does VS2005 import XP icons properly?
I imported an XP icon into my project and assigned it IDR_MAINFRAME id.
Unfortunately it looks like alpha blending is not working properly when the
application runs. Specifically app's icon displayed on the app's title bar
and on the task bar is ragged and not anti-alised on the edges. I've tried
quite a few of icons with the same results. A good example would be "ICS
Client.ico" found in VS2005ImageLibrary.
Should XP (i.e. 32 bit) icons work with VS2005 and MFC apps? If yes, what
is the proper procedure of importing them?
You can use the ico...Area Chart #2
I would like to know if it is possible to produce an area chart, where
instead of the data being shown in an upwards format (column style ) it is
shown in an acrosswards format (i.e. like an Exel bar chart).
Thanks for your help.
It's not a built-in style of chart.
You could possible use Jon's code approach, Fill Left example.
Another possibility is to use a bar chart but for each point in the series
you need to plot multiple bars.
Each of the extra bars needs it length calculated taking in to account the
slope between each ...Formatting Imported Data
I want to be able to read in a single column of data from either an
Excel file or from a column of a word document and then produce the
same column of data so that each entry has two cells separating them.
So that the column
would look like
I there a straightforward way I can do this in Excel w/o having to use
some type of additional program (like VBA)?
Nothing straightforward that I can see.
Without some manual arranging which would be onerous, you will be better off to
use a VBA macro.
Appli...Outlook 2003 Imported Emails Date Problem
I imported OE to Outlook 2003 last night, and now all my
imported emails dates are scrwed up.
Even though the properties on the emails show the correct
dates, the "Recieved" sort on the main window shows a
totally different date.
IS there a way to fix this?
...showing a break in bar chart
Can anyone tell me how to show a break in bar graph so that I can show small
bars and large bars (truncated) on the same graph.
Here are a couple of examples.
Although I notice Jon provided these links to another post you made on
> Can anyone tell me how to show a break in bar graph so that I can show small
> bars and large bars (truncated) on the same graph.
Andy Pope, Microsoft MVP - Excel
...To Mr. Liengme: Re My previous Post Concerning My Bar Chart Problem
Hello again Mr. Liengme,
I tried what you suggested, and it works just fine.
But, I really don't understand what, exactly, I am doing when
I do this cell deletion. And then "select that cell (B1) down to the last
across to C".
a. Can you explain, please what I am accomplishing when I do this ? What
happens or changes in the Formatting, or... ?
b. Also, I thought I would be clever and formatted one column as text.
This did not work. Why not ?
Thanks again; really appreciate your time and help/
Your x and y values are both num...