Rows of data, using status columns to sort data to pie chart on another worksheet tab

Hi there,

1.  I have 50 rows of data.  There are many columns, but, there is one
status column that I use to group the rows of data into
relationships.   I would like to build individual charts based on the
status column.  So, if I say these items are part of "Group A",
information from those rows that are "Group A" will automatically show
up on a chart on the "Group A" worksheet tab pie chart.  I will have
"Group A", "Group B", "Group C" pie charts on seperate worksheet
tabs.  Now, I want to move an item from "Group A" to "Group C". So, in
the status column I change "Group A" to Group C".  So now it
automatically moves off the "Group A" pie chart to the "Group C" pie
chart.

2.  Also, beside the "Group C" chart, I would to list a summary of the
data (in text format) of all the rows that are part of the "Group C"
status.  If I move the data to a "Group B" status, excel moves the
data to the "Group B" pie chart and summary list.

Phew! Was this too much for one post?? :)

Thanks!

0
3/27/2007 7:14:22 PM
excel 39879 articles. 2 followers. Follow

1 Replies
550 Views

Similar Articles

[PageSpeed] 33

On Mar 27, 3:14 pm, "Greggy" <greg.kel...@gmail.com> wrote:
> Hi there,
>
> 1.  I have 50 rows of data.  There are many columns, but, there is one
> status column that I use to group the rows of data into
> relationships.   I would like to build individual charts based on the
> status column.  So, if I say these items are part of "Group A",
> information from those rows that are "Group A" will automatically show
> up on a chart on the "Group A" worksheet tab pie chart.  I will have
> "Group A", "Group B", "Group C" pie charts on seperate worksheet
> tabs.  Now, I want to move an item from "Group A" to "Group C". So, in
> the status column I change "Group A" to Group C".  So now it
> automatically moves off the "Group A" pie chart to the "Group C" pie
> chart.
>
> 2.  Also, beside the "Group C" chart, I would to list a summary of the
> data (in text format) of all the rows that are part of the "Group C"
> status.  If I move the data to a "Group B" status, excel moves the
> data to the "Group B" pie chart and summary list.
>
> Phew! Was this too much for one post?? :)
>
> Thanks!

Maybe it's not possible.  Can someone point me somewhere?

0
3/28/2007 3:05:33 PM
Reply:

Similar Artilces:

Hiding blank rows
I have a spreadsheet with columns, first name, last name, home phone, business phone and cell phone. When I don't have phone information in any of the three columns I would like that column to be hidden or deleted. Can I do this in some automated fashion? Thanks. Michael try adding a column in that column put something like =if(counta(b2-d2)>0,"",1) and use autofilter to hide the 1s "mlkpied" wrote: > I have a spreadsheet with columns, first name, last name, home phone, > business phone and cell phone. When I don't have phone information in any of ...

Can typing macros be used in Word?
I was wondering, can I install (or program) text-typing macros into Word 2007? The type of macros that I am looking for are the only commonly found in other text editors, such as Emacs on Unix. For example, if someone types the string "zfbi" into a document, I want Word to immediately convert this string to "Federal Bureau of Investstigation. Or, "zwww" should be replaced with "World Wide Web". BTW, I have a master file of text strings (or macros) that I want Word to recognize and replace with expanded strings. So, I'm just wondering wha...

Trying to use pass through sql....
I'm trying to use pass through SQL to look up a value in another database to make sure it exists. I use the SQL_Connect and get a connection just fine. But when I try to issue the SQL_Execute I get a Dexterity Runtime error and shuts down Great Plains and sends information to Microsoft. I would appreciate any information on this. Thanks Here is the code I'm running. local long SQL_connection, status ; local string SQL_string ; status = SQL_Connect(SQL_connection) ; if status = 0 then SQL_string = "use bookcode"; status = SQL_Execute(SQL_connection, SQL_s...

Can you lock a drop-down cell so that it sorts with the row?
I have created drop-down cells (type of business) for my client contact list but when I sort that list alphabetically or by last contacted date the drop-down cells don't sort with it. How can I solve that issue? Thanks for the responses! Are these Data Validation dropdown lists? Where is the list range located? i.e. =$A$2:$A$20 If inside your sort area the lists should change to whatever is in A2:A20 after the sort. Tested in 2003 and 2007 Gord Dibben MS Excel MVP On Tue, 26 Jan 2010 13:19:01 -0800, Lisa in Victoria <Lisa in Victoria@discussions.micros...

Set up parameters for external data
Hello, In Excel i import information from an external system , (this query was orginally built in msquery). I then recorded a macro linking to this query to get the vb code to get the external data. At the moment in vb i rebuild the sql statement each time i want to import the data. For example i might want to change the date range of the imported data. Is it possible to simply use parameters , like you do in the data environment in VB6 , as opposed to recreating the sql statement each time. If so could someone please provide an example of the vb code. Cheers ...

How to change data in 300 workbooks
Hello, I have 300 workbooks in one folder, and I want to change cell a5 in all of them from "\ 04" to "\ 05". Names of workbooks are 001, 002, 003...... 300 Is there an easy way or will I have to open each of them and change the data manualy? Thanks... Hi Soky Copy this code in a workbook outside the folder C:\Data and run it Try this for all files in the folder C:\Data (it change A5 of the first worksheet) Sub Test() Dim mybook As Workbook Dim FNames As String Dim MyPath As String Dim SaveDriveDir As String SaveDriveDir = CurDir MyPath = &...

Time calculations not sorting properly
Hi, a)I have data in an access database which was imported but the some of the times are stored as 1/1/1900 10:35:00 instead of just 10:35, this wreaks havoc when i try to sort them, I did see a CDec() function in access help, but is not available? I did try a CDbl() just to see and it change the other valid times to .786etc and the 1/1/1900 10:35:00 to 2.455etc, not sure what to do here? Thanks Try using the TimeValue function on the field. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "CraigJ" <craigjl2004@yahoo.co.uk&...

Macro for merging rows
I have a fairly large spreadsheet that are sorted based on a file # (ie: E0800100, E0800101). The spreadsheet is setup to where each entry is on an individual row as seen below: A B C E0800100 Review.... 1.0 (hr) E0800100 Review.... 2.0 E0800101 Review.... 1.5 E0800102 Review.... .5 I am trying to organize the spreadsheet so that there is only one row per file number and the Descriptions (B) and Time (C) extend along the columns of that row. A. B....

Using Web Services
I just downloaded the Web Services Toolkit for Office 2003. Because our IT folks have all of our systems "locked down", I had to have one of them run the installation. Since I'm new to this, I was looking at some notes in an Access Advisor magazine on how to run web services. In the article I read, it indicates that "after you have downloaded and installed the Toolkit, Access will have a new menu item named Web Services References on the Tools menu in the VBA IDE". Unfortunately, when I run Access, I am not seeing this new menu item. Could it be a result o...

To find the Last row
The following is the pattern of the data I have. I need to know which is the last row which has the data A1 - AAA A2- BBB A3 - <blank> A4 - CCC A5 - DDD A6 - <Blank> A7 - <Blank> A8 - <Blank> A9 - EEE. In the above example I want to get the row number as 9 as the last row which has the data. Can this be acheived by some formula. I tried COUNTA, but it does not serve my purpose. Please help. Thanks Anand ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.Excel...

WEEKDAY using IF
I have a cell(C27) with the foumula: =TODAY()+1 When I open the file on Friday, it shows Saturday. I want it to show Monday. How do I modify the formula if C21 is Saturday(6), then Weekday +2 My formula that doesn't work is: =IF(TODAY()+1=WEEKDAY(6),TODAY()+3) Am I close??? Joe One way: =IF(WEEKDAY(TODAY())>5,TODAY()-WEEKDAY(TODAY(),3)+7,TODAY()+1) another, if you have the Analysis Toolpak Add-in loaded (Tools/Addins..): =WORKDAY(TODAY(),1) In article <uqXKY5g2EHA.3128@TK2MSFTNGP14.phx.gbl>, "lunker55" <this_is_not_my_email_address@hotmail.com> w...

Row colouring that accommodates filtering?
What can be used instead of "=MOD(ROW(),2)=1" that accommodates filtering, pls? The above gives clumps of identically-coloured rows, dependent on the particular filter criteria used. Thank you! :oD As long as there are no empty cells within the filtered list: Assume A1:B1 is the header row. A2:B10 is the data Select the range A2:B10 Conditional Formatting Formula Is: =MOD(SUBTOTAL(3,$A1:$A$2),2)=0 Biff "StargateFanFromWork" <NoSpam@NoJunk.com> wrote in message news:%23wKPl8LmHHA.4768@TK2MSFTNGP05.phx.gbl... > What can be used instead of "=MOD(ROW...

WLM data files
Where in the directory tree would I find the file(s) in which all of WLM's data (email folders/messages, contacts, newsgroup messages, calendar, etc.) are stored? Look in options/advanced/maintenance/store folder to find the path to where it is all stored. Art [artfudd] Folden -- "PE" wrote in message news:O_idnZXhJ6HMndLRnZ2dnUVZ_g-dnZ2d@earthlink.com... Where in the directory tree would I find the file(s) in which all of WLM's data (email folders/messages, contacts, newsgroup messages, calendar, etc.) are stored? "Art [artfudd] Folden" &...

query with duplicated data
Hi, I'm trying to do my first database and I want to compare 2 tables. Tbl 1: Invoice nmr Part nmr Value Price 1001 A 601 100 1001 B 601 500 1001 C 602 200 1002 A 601 100 1003 D 602 550 Tbl2: Invoice nmr Value SumPrice 1001 601 600 .... (part A+B) 1001 602 200 ..... (part C) 1002 602 100 ..... (part A) 1003 602 55...

How do I transfer color formats from one work sheet to another
SheetA contain a number of cells formatted in red and a number in blue (most are black). I wish to transfer this color format to SheetB, but offsetting the cells by two columns. Thus if cell A3 is red in SheetA, I want cell C3 to be red in SheetB, and if it is blue I want the color in SheetB to be blue. And I want this for the whole spreadsheet. Any help with a macro? Thanks You could select the region from which you want to transfer and then click on the "Format Painter" button on the standard toolbar. Then on the second sheet, select the column offset 2 from ori...

How do I alter the value of a data point in a chart series
How do I alter the value of a data point in a chart series You can change the value in the cell that the point represents. In Excel 2003 and earlier, you can select the point (single click to select the series, then single click again to select the point), then when the cursor turns into a double or quadruple arrow, click on the point and drag it. This capability was removed from Excel 2007. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "IanU" <IanU@discussions.microsoft.com&g...

linking data with other workbooks
Hello, I have a spreadsheet (FrontEnd.xls) whos cell gets data from another spreadsheet using (='C:\junk\[BackEnd.xls]Sheet1'!C3). I then close both spreadsheets and open BackEnd.xls and insert a column causing the BackEnd data to now be C4. Now when I open the FrontEnd.xls I am asked if I want to update the links. After choosing "Yes", the cell is still pointing to "'C:\junk\[BackEnd.xls]Sheet1'!C3" rather then to C4. Is there a way to have the FrontEnd.xls spreadsheet update cell references that have shifted because of insertions or deletion of...

Why NOT to link using pragma comment (lib, libname)
I posted a while ago about static linking, and it generated a big discussion of the merits or demerits of using #pragma comment (lib, "libname") in the source code to specify the names of the static libraries to link against. I thought I'd share something that I discovered later. My app links against a single static lib that I created. I used the pragma method to specify the library. What I found, though, was that the static library was not part of the build dependency analysis. If I changed the static library source and rebuilt the library, then rebuilt my app without ma...

Row Limit in Excel
I work a lot with excel and I know that the row limit is 65,536, but I need more than that. Is there any way to make the number of rows infinite or at least to give me a certain amount of more rows. If there is please let me know. Thank you. -- Please help Molly, that is all there is, per sheet. -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Molly" <molly_carols@yahoo.com> wrote in message news:FD2C7921-E249-4...

looking for empty row to paste a range of copied cells
Hi - I am trying to make a code that will copy a range ("A27:L27") on sheet 1 and then look for the next empty row on sheet 2 and paste it in range ("A27:L27") . I would also like the macro to insert a new blank row (or insert the copied row) for the purpose of shifting existing SUM functions on sheet 2 down. I would like those functions to be right below the copied/pasted cells every time the macro is executed. Thanks for any help - Jim A You don't Mention What column you want to sum This code will copy and paste to the fist row and then sum column D Sub Cop...

How should I debug or adobt better data processing for high speed
Hello! I have a program in MFC that collects data via USB, process it and display graphs. When data rate is relatively low(max. 1K bytes/Sec) the program works Ok but when data speed exceeds 10K bytes/Sec program goes crazy after a while and shows fictionally data . There is no problem for display section because it is buffered ( I have a buffered DC). The problem seems to be data processing. Because program is huge I can't post codes and I do not expect a solution but I try to explain general data processing scheme and I hope someone can advise me how to find weak points of progr...

Insert row with formatting from row below instead of row above?
My default Excel template has the top row formatted as a header, with bold text and a dark bottom border to distinguish it from the rows below. So if I insert a row at row 2, the new row is formatted like the header. Then I have to select the new row and remove the bold font, remove the dark border, select the header row and reapply the bottom border. Is there a way I can change the insert default so that it takes it's formatting from the row below instead of the row above. Or better yet, so that it has no formatting at all? Hi AFAIK you can't change this behaviour -- Regards Fra...

"Delivery Status Notification (Relay)" messages
Hi everybody, When sending mails to external recipients I forward all SMTP mails via an SMTP connector to a smart host. When a user sets "delivery receipt requested" in Outlook and sends a mail to an not existing external recipient (e.g. domain does not exist) the Exchange bridgehead server sends a "Delivery Status Notification (Relay)" message to the user. In the same second our SMTP smart hosts sends an NDR e.g. that the domain does not exist. Is there any way to tell Exchange not to send a Relay delivery status notficiation when sending mails via smart host to e...

calculating row by row
I would like to have Excel total the sum of a row 5 of randomly generated numbers in a 6th column, one column at a time. I have no problem generating the random numbers and totalling them but I would like to generate the first number and place it in the total column then when I initiate it generate the second number, add this to the first and place it in the total and so on to the 5th column. Is this possible? Many thanks. Unless I'm missing something here, this formula should do it for you. This is for row 2 on the sheet, and would go into cell F2 =SUM(A2:E2) That formula will &q...

Accessing Client JavaScript after Selecting Row from Grid
Hello, I am currently working with Visual Studio 2008 and asp.net 3.0 I have the following question I hope that someone can help me with: 1) I have a GridView with rows that I read from a database. 2) The user can select a row from the grid, which fires the event: protected void MyGrid_SelectedIndexChanged(object sender, EventArgs e) { <update text field on form> <call client javascript function> } 3) I have the <update text field on form> portion of the routine working, but need to call the <cal...