Sorry, here's the data!!!

Work Order Sub Code	Status Code	Work Order #
	Asset Number
MAJ	48	209996	248482
MAJ	10	242552	110140
MAJ	48	261283	266092
MAJ	10	262684	253321
MAJ	80	270587	250623
MAJ	90	278131	248482
MAJ	80	278132	248483
MAJ	80	278133	248484
MAJ	80	278137	248485
MAJ	91	312322	253966
MAJ	48	312534	254051
MAJ	48	324296	253287
MAJ	10	333233	253966
MAJ	80	333238	47488
MAJ	80	333296	47731
MAJ	90	333714	47415
MAJ	14	335426	2250
MAJ	04	335444	253317
MAJ	81	335816	254051
MAJ	10	336009	0
MAJ	91	336013	0
MAJ	48	336023	112957
MAJ	10	336409	46649
MAJ	14	337899	254074
MAJ	10	338720	47381
MAJ	10	338992	47488
MAJ	48	339020	47505
MAJ	14	343814	2250
MAJ	48	345064	48068
MAJ	48	345194	264819
MAJ	48	345196	251439
MAJ	10	345834	2250
MAJ	48	348597	256403
MAJ	10	348983	253287
MAJ	10	351241	248485
MAJ	10	356081	47489
MAJ	90	360759	253330
MAJ	11	361288	253317
MAJ	14	363598	0
MAJ	11	367899	254051
MAJ	80	368493	253966
MAJ	14	369169	276525
MED	42	150512	248491
MED	10	299648	248482
MED	48	335011	264249
MED	42	335998	253588
MED	48	336019	47440
MED	48	336022	262159
MED	90	336225	46397
MED	80	336291	248153
MED	48	336289	47492
MED	48	336294	47492
MED	10	336423	253317
MED	10	336516	254551
MED	10	336529	253285
MED	90	337470	275272
MED	90	337475	275273
MED	10	338041	254051
MED	14	340655	253643
MED	48	344531	2282
MED	48	345193	47375
MED	48	345197	47376
MED	48	345205	47380
MED	48	345207	47374
MED	48	345215	47378
MED	48	345218	47532
MED	48	345536	47490
MED	48	345540	47488
MED	70	345542	47489
MED	80	345545	47503
MED	48	346031	47490
MED	48	346032	47488
MED	70	346035	47489
MED	80	346037	47503
MED	10	346733	248482
MED	10	346766	47505
MED	80	346837	248482
MED	80	346882	248482
MED	48	346936	47492
MED	48	346938	47487
MED	48	348671	276279
MED	10	353438	253574
MED	14	353441	255756
MED	91	353442	255756
MED	14	356123	2250
MED	10	356869	110141
MED	14	356907	248482
MED	90	357183	253333
MED	10	357755	253317
MED	10	357764	254141
MED	14	358933	253317
MED	14	359103	253317
MED	80	359105	252262
MED	80	359657	0
MED	14	360230	253342
MED	14	360790	253288
MED	14	361434	253307
MED	01	361439	0
MED	80	361479	110141
MED	14	361605	253317
MED	80	363794	252954
MED	11	364468	0
MED	10	364470	0
MED	42	364472	0
MED	11	364473	0
MED	01	364806	47345
MED	48	364816	276279
MED	14	365502	253303
MED	48	366455	46156
MED	48	366456	251434
MED	01	366786	47347
MED	10	366834	264201
MED	14	367318	253332
MED	48	367698	252927
MED	12	368405	252209
MED	48	368478	252271
MED	48	369866	47496
MED	14	370435	254032
MED	01	370535	264258
MIN	10	310768	248482
MIN	10	331229	257736
MIN	80	335019	46656

0
anonymous (74722)
11/7/2003 2:55:11 PM
excel.charting 18370 articles. 0 followers. Follow

2 Replies
499 Views

Similar Articles

[PageSpeed] 32

On Fri, 7 Nov 2003 06:55:11 -0800, Rhonda =

<anonymous@discussions.microsoft.com> wrote:
> Hi, I am trying to create a pie chart from the below data
> just to show the percentages of what work orders are maj,
> med and min. How do I set this up!!

> Work Order Sub Code	Status Code	Work Order #
> 	Asset Number
> MAJ	48	209996	248482
> MAJ	10	242552	110140
> MAJ	48	261283	266092
> MED	42	150512	248491
> MED	10	299648	248482
> MED	48	335011	264249
> MIN	10	310768	248482
> MIN	10	331229	257736
> MIN	80	335019	46656

(data snipped for brevity)


Add three cells to your worksheet. They contain:
=3DCOUNTIF(A3:A124,"=3DMAJ")
=3DCOUNTIF(A3:A124,"=3DMED")
=3DCOUNTIF(A3:A124,"=3DMIN")

Now chart these three cells on your pie chart.  Note that I assumed that=
 =

your data was placed in A3:D124, with headers above.

-- =

Dave
dvt at psu dot edu
0
dvt_spam (111)
11/7/2003 3:52:57 PM
Thanks for your help!!!



>-----Original Message-----
>On Fri, 7 Nov 2003 06:55:11 -0800, Rhonda 
><anonymous@discussions.microsoft.com> wrote:
>> Hi, I am trying to create a pie chart from the below 
data
>> just to show the percentages of what work orders are 
maj,
>> med and min. How do I set this up!!
>
>> Work Order Sub Code	Status Code	Work Order #
>> 	Asset Number
>> MAJ	48	209996	248482
>> MAJ	10	242552	110140
>> MAJ	48	261283	266092
>> MED	42	150512	248491
>> MED	10	299648	248482
>> MED	48	335011	264249
>> MIN	10	310768	248482
>> MIN	10	331229	257736
>> MIN	80	335019	46656
>
>(data snipped for brevity)
>
>
>Add three cells to your worksheet. They contain:
>=COUNTIF(A3:A124,"=MAJ")
>=COUNTIF(A3:A124,"=MED")
>=COUNTIF(A3:A124,"=MIN")
>
>Now chart these three cells on your pie chart.  Note 
that I assumed that 
>your data was placed in A3:D124, with headers above.
>
>-- 
>Dave
>dvt at psu dot edu
>.
>
0
anonymous (74722)
11/7/2003 4:30:18 PM
Reply:

Similar Artilces:

hq data upload error message
I have been encountering the following message when the stores are connecting to HQ. Worksheet 401. What does this mean and how can it be fixed? <<ExecuteCommand>> Error –214727900: Cannot alter the table ‘Item Dynamic’ because it is being published for replication. This is a multi-part message in MIME format. ------=_NextPart_000_0183_01C6D3F8.F7177E60 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Debby, Try re-indexing and run a database check on both ends. Backup First!! Also, double check that you are running the same...

Extracting the data according to the number of cell
I have a minor Excel formula problem. In my example has following data, cell A5 shows "apple", A6 shows "salt", A7 shows "sugar" and A8 shows "fish". On another hand, cell B3 is the "criteria" data showing 3. My question is to form an Excel formula which can extract the data from cell "A1" and then extract the 3rd data, which is "sugar" (that is the result I want). Althought the formula is counting from A1, but the excel formula know the data after "apple" and "salt" is "sugar" (cell fro...

How can I change the chart so date is up and down and data is acro
I have a chart that has the date across the bottom (category axis) and the data up the side (value axis). I want to change these. Is this possible? Hi, It depends on what chart type you are using. Have a look at Jon Peltier's example for a line chart. http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html Cheers Andy speet wrote: > I have a chart that has the date across the bottom (category axis) and the > data up the side (value axis). I want to change these. Is this possible? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info =?Utf-8?B?c3BlZXQ=?= Wrote: &...

organising data from lines in word to excel columns
I have a word doc which contains lines of text that are formatted into sections like this: Page: Page Name Title: Page Title URL: www.page.com/page-name/ MetaKeywords: keyword 1, keyword 2, keyword 3 Metadescription: Page desc.. There are many of these in the doc that I have which I can copy and paste as plain text into excel but I then need to format them into columns likes so: Page Title URL MetaKeywords Metadescription Page Name Page Title www.page.com/page-name/ keyword 1, keyword 2, keyword 3 Page descr... Does anyo...

lookup and transfer data
I have multiple spreadsheets that I want to move certain information from to get all my info into one spreadsheet. Is there anyway to search mutiple spreadsheets by a column like "Part Number" and tell it to retrive another column like "Qty" then post it into a corresponding column in another worksheet by matching "Part Number"?? Hi some questions upfront: - how are your sheets named exactly - columns IDs - Are you searching for a numeric value only - Is there only one occurence of each part number -- Regards Frank Kabel Frankfurt, Germany ExcelDummy wrote...

Auto open an .xls, refrsh data and close???
I have an Excel spreadsheet that gets external data from an ODBC data source. I also have ANOTHER process that actually queries this Excel spreadsheet via ODBC because this other application cannot directly access the ODBC DSN that the Excel spreadsheet is attached to. (Don't ask) :-) OK, SO, Is there a way (scheduled task maybe) to have an automated process that will 1) Open the Excel spreadsheet 2) Refresh the Data 3) Close the spreadsheet but only after it is done refreshing the data? I know that I can also set up the spreadsheet to automatically refresh the data every time it is open...

Hovering Over the data point shows different X-Axis
I have an area chart with several data points. The chart looks correct, but if I hover over one of the data points the X-axis that it indicates is one off the correct X axis. If I only select data for 2 years (24 points) it is okay. As soon as I add the 25th, the hover over shows the following month (the data is still correct). Is this a limitation in Excel or has anyone else come across this? ...

crm retreives no data every 15 minutes or so
Hi Everyone, Our CRM system is unable to pull any data every 15 minutes or so. I've checked the log file and in the corresponding times this error message appears. Event Type: Error Event Source: MSCRMSecurityService Event Category: None Event ID: 6148 Date: 11/3/2004 Time: 3:26:36 PM User: N/A Computer: ACD021 Description: Error: Some security descriptors could not be adjusted after a privilege change. -2147217871 (0x80040E31) Description: <could not load message> any ideas? Thanks in advance. Mark Try reenabling all disabled business units If that doesn't fix ...

Return the Data from the last cell to the right
Hey, Let's see if I can explain this. I have a table that looks like this Persons Name0, (emptycell), (emptycell), (Date), Persons Name1, (Date), (emptycell), (emptycell), Persons Name2, (emptycell), (Date), (emptycell), Persons Name3, (emptycell), (emptycell), (Date), Persons Name4, (emptycell), (emptycell), (emptycell), Persons Name5, (emptycell), (Date), (emptycell), (I hope that makes sence) On another sheet select Persons Name from a list. I then want to show the very last entry on the afore stated table. IE, If i select Persons Name5, it should...

auto formula fill after data entry
what is the trick to have a formula fill down after a new row of data i entered. for example if i wanted to calculate miles per hour, i woul have three cells in a row; miles, hours and the formula of cell1/cell2 i want the formula in cell3 to automatically fill down when i ente values in cells 1 and 2 in each successive row. thanks in advance, joe -- Message posted from http://www.ExcelForum.com The following MSKB articles explain how Auto Extend works: XL2000: How Auto Extend List Behavior Works http://support.microsoft.com/?id=231002 XL2000: Entering Data in List May Not Extend Form...

Excel data corruption
I have a problem were data is being moved from old spreadsheets into current sheets replacing the valid data. Not all columns are affected. The first 8 columns are used as base data each mth and survey data punched into the next 7-9 columns. This is done each month with new base data and new survey input. What I am finding is that the base data in the first colums is OK but the new survey data is being corrupted with data from prior months. This does not happen to all rows but it is more than random. Severalconsecutive rows can be corrupted followed by non affected rows. There are no...

bcp data to change sort order
I have followed the TK "How to BCP Data Out and Back into a New Database (875179)" a few times and it seems to work great. However, when bcp'ng the data back in, I do notice some errors as it flashes by in the dos screen, however, NONE of the .err files show any size other than 0k. After logging into Great Plains, I do notice that some information is completely missing. I check the tables and they are empty. I checked the in and out bat files and those tables are exported, then imported, the table is empty and its .err file is also blank. If the .err files do not show...

Replace data with the result of a formula
Hello, I have a long list of names in <first> <last> format and want to change them to <last>, <first> format. I know how to do this with a fomula, but want the column with the result to have the actual text, not the formula that produces the text. The only way I've figured out is to export the result of the formula to a text file and then read it in again to replace the original column of text. Is there a better way? Place your formula in a blank column B (insert if needed). Copy Column B and in Column A use Paste Special>Values. Then Delete Column ...

running total of specific data
I have a spread sheet with multiple catagories. I want a running total of just specific catagories. Example; each time a "towels" is entered I want it to total with the last "towels" entry. Help? Assume 'towels' and the like are in column A, with count in column B, then in any column EXCEPT a or b you could use this formula: =SUMIF(A:A,"towels",B:B) Change "towels" to any other item for different results, or separate running totals elsewhere on the sheet. "ameegrl" wrote: > I have a spread sheet with multiple c...

data range
How do I choose every ninth row to be my Y data on a chart? I have 15,000 rows so picking one individually will be time consuming. Thank you. Holly Jon Peltier has instructions for this in his Excel Charting FAQ article: http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=209#jon024 Holly wrote: > How do I choose every ninth row to be my Y data on a > chart? I have 15,000 rows so picking one individually > will be time consuming. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html ...

excel graphs data labels in Pivot tables
I have a pivot table, and i have certain events, listed under the comments column that i would like those comments to appear on the graph by the date each major event happened in? ...

Excel (2007) Chart Refuses to Accept More Data Points
I have a simple chart set up that references data points which are vertically ten spaces apart. The chart has worked fine for months. However, when I went to update it with another series point today it simply will not "OK" the extra point. I click enter, I click okay, and NOTHING. It's not just one chart that this is happening with, either. In the same file I have another chart that references another point that is spaced like the previous one but I have the same problem. I've never had this happen before and tooling around with it hasn't yielded any fruit. Some sa...

using data from another spreadsheet
Is it possible to "populate" cells with info from a difference spreadsheet similar to a mail merge with a word doc? Andy Office 2007 Win XP Yes. See help on "linking" Gord Dibben MS Excel MVP On Sat, 10 Apr 2010 09:55:03 -0700, Andy Roberts <andy@blue-bean.co.uk> wrote: >Is it possible to "populate" cells with info from a difference >spreadsheet similar to a mail merge with a word doc? > >Andy >Office 2007 >Win XP If you're retrieving a value from a worksheet in a different workbook, you can open excel ...

Data Table
Dear all, I want to create a data table. Data>Table But coming a message "Selection is not valid"/"Input cell reference not valid", Plz help to create One variable and two variable data table. The data table needs to be set-up on the same sheet as the base formula (it doesn't work across sheets) I have 2* samples on data table in my free archives: *one variable data table, 2 variable data table One variable data table example.xls http://savefile.com/files/1007074 2 variable data table example.xls http://savefile.com/files/46276 The samples contain th...

Link pop up form data with main form data
I have a main form with a block of data that cannot be edited. This is what I want to happen. I have the block of data when Dbl clicked it will open a smaller pop up form with the data block in it. This can be edited. The problem is even if I change my record on the main form and Dbl click the data block the smaller pop up opens only to the first record. I want to be able to open the smaller pop up to edit the data I am currently on. Thanks for any help. Have a way to uniquely identify the block of data you want. Very often this is the primary key of the containing the ...

Pie Chart Data Labels #4
I've created a pie chart that shows the Category name in the default location (outside of the pie chart itself). That's the easy part. I need to show the Value but do not want that Value to appear after the Category name. I want the Value to overlay its respective pie wedge, like the Column chart, which places the Value over each column (which can be moved and edited independently.) On Mon, 9 Jul 2007, in microsoft.public.excel.charting, Jake <Jake@discussions.microsoft.com> said: >I've created a pie chart that shows the Category name in the default >locat...

Updating data point names
I am currently creating scatter plot charts, but in the abscence of data labels on the chart I am unable to distinguish which data point relates to what data. I was hoping not to have to actually insert the data point names on the chart, but to have the Data Point name update so that when you hover with the mouse over the point it comes up with a meaningful name for the data point. Any ideas? Jerry - Presumably the point names come from a worksheet range. There are utilities freely available that can apply the labels from a worksheet range to the points in a chart. Two good ones ar...

correlating and summing data from multiple spreadsheets
Hi, bit of a tricky one here (or not?). I've got 10 Excel workbooks (running 2007). Each workbook's got one relevant worksheet. Each relevant worksheet has about 500 rows of line-items (expenses). Each row is divided into a column, the most important one of which is, say, Column C "Vendor ID". The rest is a bunch of expense data (amount, description, etc.). What I want to do is to sum up the totals for each Vendor ID, across all 10 workbooks. What I've done so far is to simply Data/Sort each workbook by Vendor ID. My next thought is to subtotal them - but that sti...

Best solution to share linked excel data without endangering sourc
I have recently completed converting a cumbersome Lotus DOS report to a modern, macro machine... I am eager to share individual summary worksheets from a very large workbook with individual users, but am having difficulty determining the BEST (and easiest!) way to: 1) share the location summary for separate locations among small groups 2) Ensure integrity of the source document. Linking the destination files, with all protection still allows users to 'open source' when updating links.( I would need to establish file permissions to allow users to update links anyway, which would...

Finding Asymptotes from a set of data in Excel
Hi Can anyone help me find asymptote from a set of data in two column x and y that show the frequency responce of a say a freq. responce of a electrochem cell in Excel? Finding it from a function seem relatively easy but without a model for the data is there a method of finding two lines that meet to produce the turning point? Cheers WayneL ...