| Thread | Last Post | Replies |
|
| Why do my data labels do not match source data? | 11 Sep 2006 20:04 GMT | 1 |
I have created a chart but my data labels do not match the source data. The labels state, Series 1, Series 2, etc.
|
| How do I Add a variable in the legend without charting the data? | 11 Sep 2006 20:00 GMT | 1 |
I have three variables that need to appear in my legend but only two of them should appear in the chart. How do I show the third variable in the legend without it being plotted in the chart?
|
| Overlapping Bars Chart & Two Y Axes: how? | 11 Sep 2006 19:58 GMT | 1 |
I can create bar and column charts w/ 2 data sets slightly overlapping. However, when I add a secondary Y axis, the two sets of bars completely overlap w/ no offset possible -- at least not that I can figure out. Is there a way to have my cake and eat it too, that is, have two ...
|
| Bar Chart w/ Broken Bar | 11 Sep 2006 19:57 GMT | 1 |
How can I make a bar chart w/ one broken bar? One data point is significantlylarger than the others. Showing the full scale on the Y axis makes the other data points hard to read. Using a log scale allows all data points to be read, but disquises the significance of the ...
|
| Changing text formats on a chart linked to a spreadsheet | 11 Sep 2006 18:31 GMT | 2 |
Currently I have some text combined with formulae in a text box showing on a chart sheet linked to a worksheet where the original info is. In the chart sheet I would like to change the size of some of the text and add colour to some of the text as well. The text box can be ...
|
| How may I macro update a normal distribution chart from new data? | 11 Sep 2006 13:20 GMT | 4 |
In Excel 2003 SP2. I have created a form for reporting Statistical values.This includes a normal distribution chart. I want to update this chart when new sample data is entered into the form, without having to go through "Tools, Data Analysis, Histogram" each time. I have ...
|
| Extracting numbers | 11 Sep 2006 04:33 GMT | 2 |
I recently had to extract the numerical data from the text for the cells in a fairly long column. I know there are available user functions based on a loop and ISNUMBER but has anyone got a favorite method using built-in worksheet or formatting
|
| How do I not print the column letters A-Z but keep the row #'s | 11 Sep 2006 03:07 GMT | 2 |
I am trying to print a chart where I want to keep the row numbers but not the column headings A-Z printed. Choosing Page setup under the Sheets tab only lists them together not as single choices. Is there a way to customize the sheet to only list the row numbers?
|
| x or y error bars? where are they? | 11 Sep 2006 02:57 GMT | 6 |
I cannot find the x or y error bar tabs in the format data series menu.
|
| Difficult chart to compose? | 11 Sep 2006 02:51 GMT | 3 |
I would like to make the following chart but don't know how to do this. Data: - for 5 persons I have values of a variable Y at different stages of development.
|
| primary axis fitting | 11 Sep 2006 02:41 GMT | 1 |
I have a line chart, with two series on it. When i use a primary and a secondary axis, by double clicking on one serie, then on axis label, choosing Plot series in : "Secondary Axis", my chart looks like :
|
| How to graph from an imported data set? | 11 Sep 2006 02:37 GMT | 1 |
I exported results from GAMS to Excel; when I want to graph the results i get wrong results. But if I put columns in a different order then I get the right graph. What can the problem be?
|
| How do I graph a melting point calibration curve? | 10 Sep 2006 14:13 GMT | 2 |
I have a theoretical values of three compunds and I got experimental values. I am trying to graph them and it does not work Here are the values of temp: EXPERIMENTAL: x-axis
|
| summing up | 10 Sep 2006 14:09 GMT | 1 |
I have a spreadsheet with data that I wish to sum up just two columns (A and K cols). I need to filter column "A"( that column list names of items which can be repeated in any order), and totals in column "K". I'm looking for a vb code that will insert a summing sheet with the ...
|
| Charting possibility | 08 Sep 2006 23:29 GMT | 5 |
Is there a way to chart a series of data along with markers for specific events.. something similar to what http://finance.google.com have. Essentially how can this data be charted in the most informative way
|