scatter plots using pivot table data

In older versions of Excel, you could directly create xy 
scatter plots using pivot table data.  In Excel 2000, the 
chart wizard says you can't use an xy scatter plot with 
pivot table data.  Why?????  Is there any way around this 
limitation?
0
drogers (1)
6/9/2004 3:21:15 PM
excel.charting 18370 articles. 0 followers. Follow

1 Replies
2483 Views

Similar Articles

[PageSpeed] 55

Dan -

Don't tell the pivot table you're making a regular chart.

Select a cell away from the PT and start the chart wizard. Select the XY 
Scatter type you want in step 1. In step 2, use the Series tab to select 
the ranges for the names, X values, and Y values of each series in your 
chart. Make sure you don't select one of the PT buttons.

I do this all the time, because I use pivot tables a lot, and I hate 
pivot charts.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Dan wrote:
> In older versions of Excel, you could directly create xy 
> scatter plots using pivot table data.  In Excel 2000, the 
> chart wizard says you can't use an xy scatter plot with 
> pivot table data.  Why?????  Is there any way around this 
> limitation?

0
DOjonNOT (619)
6/9/2004 11:54:08 PM
Reply:

Similar Artilces:

transferring data
Dear sir,with best regards, i have in attached file a scheduale contains some data like(invoice no.,date,amount, agent) ,i ask you kindly to help me to transfer these data to (agents scheduales ) as mentioned in the attached bit from my workbook ,i am using excel 2003 and optained a (pivot table)solution but i need (formulas or code ) one . Thanks in advance. -- tofimoon4 ------------------------------------------------------------------------ tofimoon4's Profile: http://www.thecodecage.com/forumz/member.php?userid=138 View this thread: http://www.thecodecage.com/forumz/showthread.php?...

on a scatter graph, how do i insert a line indicating the mean?
as above Create corresponding cells that each contain the mean, then "Chart|Add Data" to add this new data series to the chart. Jerry caro wrote: > as above ...

Exporting data into Word from an Access Form
Hi Folks, If these a way to export data with a command button on a form into Word? Any help on this will be very appreciated, Thanks to all, Fred's Fred "into Word", ... do you mean like a Word merge document? Regards Jeff Boyce Microsoft Office/Access MVP "Fred's" <frederic10_mess@hotmail.com> wrote in message news:1187301137.513832.145940@l22g2000prc.googlegroups.com... > Hi Folks, > > > If these a way to export data with a command button on a form into > Word? > > Any help on this will be very appreciated, > > Thanks to...

Custom lines on xy plot
I want to make a custom line on an xy plot. The colors and lines that excel has by default don't fit my needs. Thank you for your help. I can provide more explanation. -- schnett ------------------------------------------------------------------------ schnett's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=12035 View this thread: http://www.excelforum.com/showthread.php?threadid=521295 > I can provide more explanation. We're all ears. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://...

Disable Save unless a Macro is used
Ive looked through the posts but i cant seem to make this work. I have workbook that automatically updates from another and then saves itself The trouble is I dont want the people using the workbook to be able t save it. As far as the user is concerned, when they press Save o SaveAs nothing happens OR they recieve a message to tell them it won save. When the update from another workbook is recieved I want th Macro to be able to enable save, save the workbook, the disabl save/SaveAs. Please can someone help me? -- Message posted from http://www.ExcelForum.com Hi you can put the following ...

Using the wildcard * character
=SUMPRODUCT((Description!$B$1:$B$5000=A2) (Description!$A$1:$A$5000=$B$1) * (Description!$C$1:$C$5000="2.0")) Hi I'm using SUMPRODUCT to find matching data within 3 columns. At th end of the statement above I have ...="2.0")), but what I want it to d is to match the cells that start with 2.0 and then have anything els after it. I know I have to use the * character but I am not sure how. Thanks for your help! R -- Message posted from http://www.ExcelForum.com Hi, Try changing the last part to something like this: Match those starting with 2.0 ....*(LEFT(Descri...

How to find the most recent product (using group,last and first)
I am working with a production system, but now I have a need to filter out only the newest version of a product (to export it to the sale/ logistic-system). I have tried using Grouping, Last or First in a query, but find that sorting has no effect. The only thing that seems to me to control what is first and last is the time of the recording of the record. I have tried sorting a query and using this as source for grouping - with no effect. Sincerely Hans Kristian Eide Do you have a date field that identifies which record is the last version of the product? Or do you propose to identifiy ...

Opening File using default viewer
Hello, how would I go about opening a file using the default viewer, so for example, if the file is a txt file, then notepad would open it. Or if it is an XML file, then maybe firefox woulld open it. I was hoping to use a CButton and if the user clicks on it, then it would grab the path specified and open the file with the corresponding viewer. thanks. Jon wrote: > Hello, how would I go about opening a file using the default viewer, so > for example, if the file is a txt file, then notepad would open it. Or > if it is an XML file, then maybe firefox woulld open it. > > ...

exclude certain data
Hi I have a series of data in rows which are plotted on a simple line chart. Sometimes I want to exclude a particular data row from appearing on the chart by typing X in a column (I currently use this to exclude that row of data from average & mean calculations, which I also plot on the same chart) Also, I have upto 30 rows of data printed on one chart - is it possible to scroll the the dataset & highlight the chart line that the data belongs to. I do not have labels because it makes the charts too crowded I'm sure I've seen this somewhere but can't find it again Ma...

Hide data in a field on a form
I have Privacy Act protected data that I would like to hide from general users of a database with permissions for specific users. I'd like the data to appear as a series of asteriks with a "show" botton that pops up a new box with a warning that data is not to be disclosed. Any suggestions? Check out Password as Input Mask. -- Build a little, test a little. "Tammy S." wrote: > I have Privacy Act protected data that I would like to hide from general > users of a database with permissions for specific users. I'd like the data > to ap...

Ensuring deleted data cannot be recovered
I have developed an excel/VBA workbook for processing and displaying sensitive commercial information. I'd like to use the workbook for a number of clients, but need to ensure that when I pass a "clean" copy to a client, he/she will not be able to recover information "left over" from a previous client's processing. My question is: If I delete information from a worksheet, save under a new name and then email the new version to someone, how do I ensure that the deleted information cannot be recovered at a later date, either using built in tools or specialis...

HOW IS F3 USED WTH EXAMPLE
hi guys reply me soon 1) In A1 type a number such as 12% 2) With A1 still selected, in the Name box (box to left of Formula Bar) type the word taxrate and press Enter. You must press Enter for this to work! 3) Let's confirm that you have named the cell A1: click on cell D1, now click on cell A1. The name box should not display "taxrate". If not, repeat steps 2 4) In A2 type a number like 100 5) In B2 type =A2* and then tap the F3 key. A dialog box opens, select the entry "taxrate" and click the OK key. Another way is to double click the "taxrate" entry....

using common control version 6 in VC6
Hi all, I'm trying to use the common control version 6 in my MFC project, I've imported the manifest.xml adn specified 6 as the platform, but I still can't use the version 6 members of the NMLVCUSTOMDRAW structure in my custom drawn controls. for instance, when I tried to use clrFace of the structure, it would say 'clrFace' : is not a member of 'tagNMLVCUSTOMDRAW', and I've traced the problem to the definition of the strucfure itself, typedef struct tagNMLVCUSTOMDRAW { NMCUSTOMDRAW nmcd; COLORREF clrText; COLORREF clrTextBk; #if (_WIN32_IE...

Scatter Chart #2
I am attempting to create a scatter chart utilizing the following data: Number of Products, % of Sales, and Employee Name. I want each point on the graph to be the intersection of Number of Products and % of Sales for each employee (easy to do). However, when I hover over points of the graph with my mouse, I want the data label to show the Employee Name appropriate for each point. Please help! Megan - Tushar Mehta has an addin called Hover Chart Label on his web site, http://tushar-mehta.com. For permanent labels (that you don't need to hover over to read), try Rob Bovey's Cha...

XY Scatter charts
Hi I cant for the life of me work out how to create the type of graph im after. I have two collumns of data-i want the first collumn to be the x values and the second collumn to be the Y values. I want excel to then plot these points on a scatter graph (eg a point on the graph will comprise of an X value and its corresponding Y value). Does anyone know how i can do this or where i can find out? Any help will be great as i am really starting to tear my hair out now!!! Pleeease! Thanks Steve highlight the first and second column data click the chart wizard icon which looks like colored ...

how to automate invoice using excel database
I have our stock listed in excel and want to be able to type a quantity and stock number into an invoice form and have it complete the details price and description from the excel database. Can this even be done in excel. Have seen many references to doing similar in access but not sure if I can in Excel. i an using excel 2003. Any help greatly appreciated. hi. very easy to use a vlookup function. i regualrly use this to fill in customer data at top of form and then fill the invoice with qty, desc, price and extension. check out the VLOOKUP function...to me it is one of the most usefu...

Summing payment records in a query but restricting it to variable dates in another table
I have a complicated query I need to run and am not sure how to approach it...looking for some guidance. I have 2 tables: 1) tblPayments (contains a list of payments made to an Applicant) 2) tblAuditCheck contains a list of Applicants with a variable 'cut- off' audit date) tblPlayments has fields: ApplicantID, DateOfPayment, AmtofPayment tblAuditCheck has fields: ApplicantID, DateofAuditCheck Example data from tblPlayments is as follows: ApplicantID DateOfPayment AmtofPayment 1 17/07/2006 =A310,000 1 29/07/2006 =A32,500 1 19/09/2006 =A31,000 2 15/09/2006 =A31,200 2 19/09/2006 =...

Why do OWC charts aggregate data when Excel doesn't?
I have charts in Excel that have in excess of 200 values on one axis. They are dates, and each value is for a day. When I create a chart in Excel, it looks fine when I run it in Excel, but when I save it as an interactive HTML file, the chart ends up grouping the data into a range of dates (eg 14 days), and then the sum of the values. How can I get the HTML/ActiveX chart to show me the same thing as in Excel. I've been poring over the generated XML, but can't for the life of me figure it out! Anyone know what the problem could be, and how to remedy it? ...

Scatter Graph
I am using Excell 2000 Can anyone point me to a good description of how to create a scatter graph? I am trying to do my first scatter graph and it does not look right. HELP - HELP - PLEASE! Aurora Jon Peltier has a charting tutorial that may help you: http://www.peltiertech.com/Excel/ChartsHowTo/Charting101.html Aurora wrote: > I am using Excell 2000 > > Can anyone point me to a good description of how to create > a scatter graph? I am trying to do my first scatter graph > and it does not look right. HELP - HELP - PLEASE! -- Debra Dalgleish Excel FAQ, Tips &am...

Data Table
Hello, I have a graph measuring two points of data. But I just want to see one of them in the Data Table and both in the graph. How do I visually get rid of one of the data in the data table but keep it visually in the graph? Thanks in advance. I don't think you can. I think you'd have to just put the "data table" in manually, because, as far as I know, an actual data table is what it is and doesn't give you much room for customization. -- Echo [MS PPT MVP] http://www.echosvoice.com What's new in PPT 2010? http://www.echosvoice.com/2010.htm Fi...

Using a sub procedure to change a subform property
I am currently using the following code to change the AllowEdits property on any form. The form calls the Sub procedure through a button's OnClick event. Sub UnlockForm(strFormName As String) On Error GoTo Err_unlockform If Forms(strFormName).AllowEdits = False Then Forms(strFormName).AllowEdits = True MsgBox "Form is now unlocked for editing." End If Exit_unlockform: Exit Sub Err_unlockform: MsgBox Err.Description Resume Exit_unlockform End Sub I am trying to call this Sub procedure from a button on a subform. I was going to us...

how to modify integer values in an access db using ADO
hi, does anybody know how to modify integer values in an access database using ADO. It seems all data types can be modified except integers that throws exception. thanks, Behzad ...

Locking all but a few data input cells
I have a worksheet that takes a few input parameters and does a bunch of calculations. I would like to protect the cells that are not for data entry so I don't accidentally overwrite a formula I spent hours debugging. ;-) I am only interested in protecting the worksheet from myself at this time, so if there is a simple, but less secure way, I would be interested in that. By that I mean a way to easily lock and unlock individual cells while I am still making changes. I would also be interested in a more secure method for later. Here's what I have done so far. I am using Excel 2007. ...

Use crm?
I would like to know what Microsoft product(s) would be could used for the following results and what the price of the recommended product would be: I work for a small company that would like to keep track of the following: 1. the workload of each employee, 2. how many hours are assigned to each each employee for a project, 3. How many hours each employee have spent on each project, 4. A way to tell if an employee is on track for meeting the project deadlines, 5. A way to tell an employee how many hours they should be working on each project they are assigned to. 6. A way to...

Cannot use the Customize Outlook Feature
I have users on Windows XP Pro and Outlook 2000 on Exchange 2000. One of my users is complaining that they cannot use the customize outlook today feature. Is there some kind of incompatability issue? I also noticed that it worked on a computer running Windows 2000 pro and Outlook 2000 Pro. Please advise. Thank you. The following MSKB article provides the fix for this issue. OL2000: You Cannot Customize Outlook Today After You Install Critical Update 813489 for Internet Explorer: http://support.microsoft.com/default.aspx?scid=kb;EN-US;820575 -- Jocelyn Fiorello MVP - Outlook *...