Graph x Data table

I have a problem. My graph doesn't keep the number format of the data table. 
I want to compare different concentrations as 10 until 10000 using 10 raised 
to a power of 1, 2, 3 and 4. In the table I've got it, but in the graph the 
number doesn't stay raised.
How is the solution for this problem?
Thanks a lot,
Sania
0
SAS (7)
11/27/2007 2:39:00 PM
excel.charting 18370 articles. 0 followers. Follow

1 Replies
379 Views

Similar Articles

[PageSpeed] 38

I would suggest eliminating the data table and building a similar type of 
table using worksheet cells.  The worksheet cells will allow much more 
flexibility with how the data is shown.  Assuming an embedded chart, when you 
want to copy or print your graph you will need to select the range that 
includes both the chart and the data table worksheet cells.

Another alternative might be to use Excel's camera tool to place the 
worksheet cell data table into your chart.

-- 
John Mansfield
http://cellmatrix.net





"SAS" wrote:

> I have a problem. My graph doesn't keep the number format of the data table. 
> I want to compare different concentrations as 10 until 10000 using 10 raised 
> to a power of 1, 2, 3 and 4. In the table I've got it, but in the graph the 
> number doesn't stay raised.
> How is the solution for this problem?
> Thanks a lot,
> Sania
0
11/27/2007 5:25:01 PM
Reply:

Similar Artilces:

Failed move data for ISV Config
I have seen this issue on the MS Knowledgebase and on the newsgroup, but my problem seems a bit different. I did a fresh install of my laptop along with the CRM 4 Outlook client. When I try to go offline, I get "Failed to move data for entity 'ISV Config' during action Insert, countRows=1." I have seen similar issues posted with specific entities noted - but the ISV Config seems different from what I have been reading. I followed the KB article, but still the same problem. Any suggestions? Thanks - JM ...

"Link to other data source"
When I open my workbook, I get a message asking if I want to update the links to other data sources but I can't find any formulas that reference another workbook! I copied a sheet from another workbook into this workbook and thought I updated all formulas, but obviously I missed one and can't seem to find it. Any suggestions for quickly finding the formula that's causing this? what version of Excel are you using? If 2003, you can select Edit - Links to view all linked documents associated with the one you are viewing. You can select a linked document and click the &qu...

SQL Data transfer to a Contact Public folder
We are trying to find a way to get Data from SQL to a Contact Folder in Public folders on ex 2003 sp1. We can do anything necessary to the SQL data but getting it into Exchange Publis Folder in the hard part. We really would like to automate this task since the Data in the SQL is updated regularly. Any ideas are welcomed. We have used basic pst imports and etc. We need something with more flexiblilty and automation, like a DTS package transfer. ...

Upgrade warning with CPY tables
This one company of many always gets a warning during table update. It is with tables CPY30250, CPY30150, CPY50250 and CPY40205. It says The table does not exist in the database. Recommended Action says "This is not a problem unless this table really exists but was not found because of path problems". These tables DO exist. This company does run Canadian Payroll with no problems. Is this something that can be fixed? I am upgrading to GP 10.00 (from 9.00.0337) this weekend. thanks. Barbola, I am not entirely in tune with Canadian Payroll tables, but if you run the followin...

Pivot tables
I have a pivot table. The columns are month and rows are sales people. I want to display the grand total for the current month from the pivot table in another cell. The pivot table is based on a named range so the grand total line may not always be in the same row. Is that even possible? If so could someone please point me in the right direction. TIA gls858 Hi Use the GetPivotData function - which will adjust to where the value is held. For more information take a look at http://www.contextures.com/xlPivot06.html -- Regards Roger Govier gls858 wrote: > I have a pi...

Scrape a website tet string into access table
I'm try to search some websites for a string which, if found, will be added to a table along with a time stamp. On some sites this works and other it doesn't. The vba code hangs up a different points in the process no matter what I try. Even something simple such as Create IE object Refresh website Close IE object Is this as IE problem or Access. There is very little help on this subject around. Hi Sorry but you will never get this to work (other than the open IE Object). This has nothing to do with access or IE. Some website "REALLY" do...

Needing help automatically generating info from a table to a form
I'm creating a database for a project at work and I'm a little rusty with Access 2003 so any help would be greatly appreciated. I've started with a table that I have imported from Excel that contains the employee's clock number, their name and their supervisor in respective columns. I would like to create a form that has three boxes. The first is a box that allows the user to key in (or possibly select) an employee clock number. Once this is completed I would like for the employee's name and supervisor to automatically appear underneath the first box. I'm ...

Data Validation Dropdown
we are using Excel 2002 with one sheet has some data validation dropdow allowing a list of value like "A,B,C,D". it had been OK then all o sudden all dropdown lists disappeared even though the data valiadatio object are still there. there is doc'ed problem in MSDN for excel 97 with freeze pane but i doesn't apply to our situation. I remove all pane and pagebreaks, still dropdown list doesn't show. any help appreciated -- jliu200 MS programmer for financial industr ----------------------------------------------------------------------- jliu2000's Profile: http://...

Pivot Table Report
Hello, I have a pivot table linked to an Access database. I want to sum 2 of the columns. I already have them in the data area (where summed data should be). I'm trying to sum the 2 colymns at the bottom within the pivot table area? ...

Making a Logarithmic Graph
Hi I'm somewhat of a newbie in terms of using MFC and I'm continuing work on a project that already has a linear graph class. What I need to do is implement a logarithmic graph. I know that there is no short-cut for making graphs with MFC and that's why the linear graph class draws everything manually. I would like to know how anybody here would proceed to achieve this. I have a basic idea of how the scale might be made but considering the pre-existing graphing architecture that allows the user to rescale the linear graph. Jumping into this seems overwelming considering all the p...

Excel data to Word for Mail merge
--____VIGFOREMMRBSJAZWDOXY____ Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: base64 Content-Disposition: inline; modification-date="Tue, 5 May 2008 05:45:46 -0500" SSBoYXZlIGNyZWF0ZWQgYW4gZXhjZWwgZGF0YWJhc2UgdGhhdCBsaW5rcyB0byB3b3JkIHRvIGJl IHVzZWQgZm9yIGEgbWFpbCBtZXJnZS4gRm9yIHRoZSBtb3N0IHBhcnQgaXQgd29ya3MgZmluZSwg aG93ZXZlciBpIGhhdmUgY2hlY2sgYm94ZXMgaW4gbXkgbGV0dGVyIGZvciB3b3JkIGFuZCBJIHdh cyB3b25kZXJpbmcgaG93IEkgY291bGQgaW5jbHVkZSBkYXRhIGZyb20gZXhjZWwgdGhhdCBsaW5r cyB0byB0aGUgY2hlY2sgYm94ZXM/DQoNClRoYW5rcywNCkRhdmlk --____VIGFOREMMRBSJAZWDOXY____ Content-Ty...

Chart Data Table, Data Range, etc. do not update on Chart
I have two Excel Workbooks. Workbook 1 contains the data and a line chart. Workbook 2 contains just a line chart of the same data as in Workbook 1. I copied the line chart from workbook 1 to workbook 2 using copy/paste. If the amounts change with in the existing data range then both line charts (workbook 1 & workbook 2) update fine. However, when I need to change the range of the data to include more cells only the line chart in workbook 1 is updated. The line chart in workbook two does not reflect the changes to the data range made to the line chart in workbook 1. What is the best ...

getting information contained in the design table to an excel spreadsheet
I am trying to copy the fieldname data and data fields to an excel spreadsheet. using the copy function in access does not provide a paste option in excel. I'm new to this so theres probably a simple sollution but i cannot find it in the help instructions regards jimh While in Access - With the desired Table Open, Click on the menu Tools, Office Links, Analyze it with Excel. Done. HTH "jimh" <anonymous@discussions.microsoft.com> wrote in message news:889a01c3e97f$da0820b0$a501280a@phx.gbl... > I am trying to copy the fieldname data and data fields to > an e...

which chart/smart art to use to show this data in power point 2007
Data: CHC is referral unit for 4 PHC's.PHC is a referral unit for 6 sub centres.There is one sub-cenre for every four villages... There are total of 175 CHC's and 1500 PHC's . Sounds like an org chart to me. But that's a lot of info to try to put onto an org chart on one slide. You could span it over slides if it's important for the audience to really see all that info. Somehow I don't think it is, though. You need to decide what the point you're trying to make is. Maybe it would be better to show dots on a map and just say that one CHC refers to ...

Shrinking Graphs in Excel 2007
We have a particular issue with some spreadsheets and shrinking graphs on each 'save as'. As they have older VB code, we can’t save it under excel 2007 format and need to always save under 97-2003 format. This issue only started occuring in the last month or so. It occurs on all PC's and for all sheets. Is anybody aware of this issue or know if a hotfix is coming out? Many thanks Sean, there have been other postings on shrinking graphs (you can see for yourself in the Search facility). I wouldn't hold your breath for a hotfix. "seanpottinger" w...

Data fit
Hi, I need to fit some data points to a function: y = A.(1 - exp(-B.x)) and get the best-fit values of A and B. It seems excel comes with some push button fitting functions (linear, polynomial) but not custom ones. Is this the case? If so, what do people generally use to fit their data? Thanks, Ciao. Put trial values for A and B in two cells. Create a new column with an estimated value (based on the A and B cells) for each observation in the data set. In another cell, calculate: - the sum of squared differences between actual and estimated observations (for least squares estimation) or -...

Data Point Label
Hi, I am trying to create a scatter plot in excel based on the following data set. X-Axis: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Y-Axis: 10.5 11.5 12.5 13.5 14.5 15.5 16.5 17.5 18.5 19.5 20.5 21.5 22.5 23.5 24.5 Everything is fine upto this point, I get the plot with points labeled by the values from Y-axis. But what I want is to label them by the following: Labels: A B C D E F G H I J K L M N O I could not find any option to pass a set of labels in excel charts. Any help is highly appreciated. Thanks, Sumanta You can use Rob Bovey's XY Chart Labeler to add the labels. It...

Converting lists to tables
I have a list of addresses that I should like to convert to a table, they each contain 4 fields, as follows: John Doe 123 Street Anywhere Anytown Bill Bloggs 456 Road Somewhere Someplace I should like to convert these names to: John Doe 123 Street Anywhere Anytown Bill Bloggs 456 Road Somewhere Someplace The list contains several hundred names and addresses so idealy I would like an easier way to do this that repetitive cut and paste. Paul Assuming the list is in column A....... In B1 enter =INDEX($A:$A,(ROWS($1:1)-1)*4+COLUMNS($A:B)-1) Copy across to E1 then copy B1...

retrieve information from table
From the table below i want to retrieve for example the figure "6" (6 i input in another cell) and put the outcome somewhere else on my sheet i the following order: input: 6 (for example =b1) bookings: 2,3 fee: 3,2 How can i retrieve an input number from a table and put the results a above somewhere else (bookings and fee are the names of the x-axis an y-axis ) Hope there is somebody who can help me! Thanks ;) fee bookings 1 2 3 2 2 4 6 2,1 2,1 4,2 6,3 2,2 2,2 4,4 6,6 2,3 2,3 4,6 6,9 2,4 2,4 4,8 7,2 2,5 2,5 5 7,5 2,6 2,6 5,2 7,8 2,7 2,7 5,4 8,1 2,8 2,8 5,6 8,4 2,9 ...

Re: MICROSOFT MONEY 2005
I'm assuming you converted 2004 file to 2005. If this is so, money will generate a backup of 2004 before converting. Do a search for a file ext *.m1? or *.mn? <<Okay MVP's. I concede. Like John Kerry, I admit defeat. I should have backed up the Money 2004. I should have backed up my data. Still, does anyone have a fix to this problem? I guess it's happening to hundreds of people. Anyone hear an answer yet? ...

Multi-Table Reports
Having difficulty creating a report that involves multiple tables in Report Wizard. Followed step-by-step instructions in book...doesn't work. Unable to locate solution/answer to question on Help...? -- Thxs-ddtadams You'll find you have much more flexibility in creating reports if you use a query to connect all the tables together you need in your report, then base the report on the query, instead of trying to connect the tables directly for the report. Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and serv...

collect data from mail merge
If I create a mail merge in Word with some blank space for data entry, can I collect the feedbacks from returned word file, and consolidate them in excel ? Can you give a little more information about what you are trying to do. Excel is a pretty powerful tool; almost certainly you can do what you want. Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "data collection" wrote: > If I create a mail merge in Word with some blank space for data entry, can I > collect the feedbacks from returned wo...

how to prepare 3 dimension graph in excel
I am trying to draw a graph in X, Y, Z axis but cant get throught, I was sucessful in drawing in two axis X,Y can any one help me in this. This might help. http://www.tushar-mehta.com/excel/charts/3d_surface/ "Som Chatterjee" <Som Chatterjee@discussions.microsoft.com> wrote in message news:7A8CC555-B21E-43F8-B9A9-D1DCA1C9EB68@microsoft.com... > I am trying to draw a graph in X, Y, Z axis but cant get throught, I was > sucessful in drawing in two axis X,Y can any one help me in this. > Andy Pope offers this approach as well: http://andypope.info/charts/3d...

SQL Table conflicts? 1.2-3.0 upgrade failure?
Hi, I am trying to track down why I cannot upgrade from 1.2 to 3.0. Since I know little about SQL could someone please help me understand why there are about a dozen conflicts in both MSCRM and METABASE tables? The conflicts look something like conflict_CRMMetaPub_COMPANY__METABASE_Attribute (about a dozen more) There are a similar entries in the MSCRM table. I have tried going offline/online with all the clients to see if that clears the conflicts. What I find curious is that all the dates are creation dates of July, 2005 when some customizations were done. I get an "Action Mi...

Charting data from many files
I have a weekly summary archive that I do of our cash flows. I would like to make a chart that shows the change in different account balances over the last year. Every single file is done in the exact same format -- same pages, same columns, etc. Is there a way to get this information together without having to go into every single file? ...