| Thread | Last Post | Replies |
|
| Stacked and Column Chart | 01 Nov 2007 00:07 GMT | 3 |
Using the data below I would like to create a single chart with a Column Stacked Chart for Revenues and a Column for Expenditures. Can u help me? Revenues FY03 FY04 FY05 Private/Local Govt. $1,500,928.00 $2,598,394.00 $7,030,199 ...
|
| Help need to create Advanced Stacked Chart | 31 Oct 2007 20:48 GMT | 1 |
I need to create a stacked chart with the following: 1. dollar amount along the y axis 2. budget for Fiscal years 1-6 along the x axis 3. Stacked on fiscal years 1-6, I need to place the additional amount that
|
| Value (Y) axis crosses between categories and Secondary Value (Y) Axis | 31 Oct 2007 20:03 GMT | 2 |
I have 7 series on my chart Series 1 is column chart - may be area chart eventually (2007 data) Series 2 is column chart 2008 data Series 3 is column chart 2007 avg
|
| Correlation Charting | 31 Oct 2007 17:20 GMT | 1 |
How do I get two colums of data to chart next to each other when their vales are very different, so the Y axis is only charting the bigger value. Ex. Sales values in weeks 1 - 8 range from 50,000 - 100,000 and hours worked range from 30 -50. I want to show the correlation on ...
|
| percentage/figs on the same graph | 31 Oct 2007 14:11 GMT | 1 |
I am trying to produce a chart showing monthly number of referrals for 4 people and with another column showing percentages. The chart i have chosen is column with a line to show the percentage fig. The first column (A) has there names. Column B has there monthly totals and
|
| graph normal distribution | 30 Oct 2007 21:11 GMT | 1 |
Hi, i'm trying to get a bell curve graph with a STDEV of about 5 and a mean of 13.8. I tried graphing the 1, 2, and 3 stdev above and below the mean and that didn't work. I just noticed this tutorial http://www.tushar-mehta.com/excel/charts/normal_distribution/index.htm,
|
| Oriented datapoint markers on chart | 30 Oct 2007 17:37 GMT | 2 |
Is there a way by which the individual datapoints on a chart could have oriented markers that would be angled based on the vector/ direction of that datapoint - basically the datapoint's marker is pointed based on a direction relative to north.
|
| create multiple scatterplot from 3 columns | 30 Oct 2007 16:33 GMT | 4 |
Is it possible to create a scatterplot with multiple series (>2) from a dataset with 3 columns: group X Y A 1,9 9,6
|
| combination chart x-axes | 30 Oct 2007 16:09 GMT | 2 |
How can I make sure that the categories for a column chart are equally distributed along the whole length of the x axis to correspond to the scatter chart series. The x-value of the scatter chart and the categories of the column chart are dates, and I need them to be aligned. ...
|
| Format charts in Excel using a template | 30 Oct 2007 15:58 GMT | 1 |
Formatting charts in Excel. Office 2003 (11.xx) SP2 Not clear if there is a way to impose a template on an existing Excel file, or if templates are used to start ne files only.
|
| Multiple chart types on same chart | 30 Oct 2007 15:57 GMT | 1 |
I have following data in columnar format Quarter of the year (e.g. Q1, Q2, Q3, Q4) Geographic zone of organization, e.g. (North, East, West, South) 4 Top selling products of the company (P1, P2, P3, P4)
|
| Setting Chart X and Y values indirectly | 29 Oct 2007 20:39 GMT | 2 |
I would like to set X-Values in my chart in a cell of a worksheet, so that when the range of my x-values changes I will not have to go into the wizard and type it again. For example, I want to use the following X-values in my chart:
|
| Horizontal axis laying on chart | 29 Oct 2007 15:51 GMT | 4 |
I'm using Excel 2007. I have two columns, each with a header. One column is dates and the other prices. I select both columns, including headers. Then I select a line chart. It plots just fine and the veritcal axis reads off the prices. The horizontal axis is in
|
| What's equation for R-Squared value given for chart trendlines? | 29 Oct 2007 13:39 GMT | 4 |
I am using an exponential trendline in an Excel Chart and want to replicate the R-Squared value the chart wizard gives. I know that RSQ would give me this were I dealing with a linear trend. However, with exponential Microsoft Help just says a "transformed regression model".
|
| Curve fitting Z=f( X & Y) | 29 Oct 2007 13:37 GMT | 2 |
Is there a way to curve fit Z= f (X & Y) in excel....Thanx Tayseer
|