| Thread | Last Post | Replies |
|
| Charting text? | 09 Mar 2006 00:24 GMT | 3 |
I have a user that has a column with text entries like "Accounting" "Marketing" etc. He wants a column graph where the more "Accounting" appears in the data column, the taller the chart column. Does anyone have any ideas how to do this? I'm thinking a "Count" function, but there ...
|
| xy scatter plot question | 09 Mar 2006 00:16 GMT | 2 |
I have xy scatter plot using dates for x axis. I change the min and max on the x axis weekly. The problem is that the lines are "bleeding" over the y axis. How do I make the lines go to the edge of the y axis but not over? (make sense?). thanks
|
| Charting number of "name" occurences | 09 Mar 2006 00:14 GMT | 1 |
:confused: Can someone tell me how I can chart the number of times a name occurs in a column? I would really appreciate it. Maybe just like a pie chart that everytime a new name is added it adds it in the chart, and everytime a name is repeated it just adds to the count of the name
|
| How can I graph functions on Excel like a graphing calcutator ? | 09 Mar 2006 00:11 GMT | 1 |
Is there any way to graph functions in y=mx+b form (or quadratic, etc.) in Excel, similar to graphing calculators, without creating a range of outcomes then graphing them?
|
| specify date source for x-axis (adjacent to data column in Excel) | 09 Mar 2006 00:06 GMT | 1 |
MS Excel 2002: From a column of dates and an adjacent column of dollar values, how do I specify the dates in the first column as the source of dates displayed on the x-axis of a related chart (in another worksheet in the same workbook)? The plotted dollar data shows correctly ...
|
| Simple Bar Charting Problem: Would Sure Appreciate Some Help On This | 09 Mar 2006 00:03 GMT | 1 |
Boy, do I feel dumb in asking this, but, honest, I've been playing around with this for hours, and just can't get what I want. I'm new at Excel Charting, so let me blame it
|
| How to show total in pie chart (Excel 2000) | 08 Mar 2006 21:55 GMT | 3 |
I'm designing a "dashboard" and only want charts, not the raw data, but I have been unable to show the total of all slices. I need to show the total number of calls taken at the help desk and the % of the total for each type (slice).
|
| Changing Time Scale to Seconds on Excel Chart | 08 Mar 2006 21:29 GMT | 2 |
My students are plotting the temperature of a liquid over time. We can make a beautiful line graph, but the scale of the X axis is wrong. It should show tick marks at 30 second intervals, but instead it just shows 1, 2, 3, etc. I have tried checking off "time scale" when I ...
|
| Line Chart | 08 Mar 2006 21:27 GMT | 1 |
I am using Excel 2000. I have a line chart that charts 4 sets of data, by month, for 1 year. I am using the 4th type sub chart type of line chart. My data points are OK except for the last point which is always down at "0" - the bottom of my
|
| Line Chart - 2 | 08 Mar 2006 21:22 GMT | 1 |
I am using Excel 2000 How do you tell which chart you have used? Ex: I have a line chart that does exactly what I want it to do and another one that does not. How do I tell which chart I used. I tried selecting the chart, right clicking the
|
| Matching the min & max values for Primary and Secondary axes | 08 Mar 2006 17:56 GMT | 2 |
I am constructing a tricky scrolling chart that makes use of dynamic named ranges to allow me to chart a defined number of months of data (eg. 6 months of sales figures) from a total of 30 available months. This is all easy to understand and setup with offset formulae and custom
|
| how can I connect data in cell C to data in cell D? | 08 Mar 2006 17:47 GMT | 2 |
I have allot of data, for example cell A is gender, cell B is year of birth and cell C is respondentnumber, cell D is also respondent number and cell E is kids yes/no. Cell C and D are both respondentnumbers, but they are both from different datasources, I need to connect the ...
|
| Need 2 rows to display X axis data points for a line graph | 08 Mar 2006 17:34 GMT | 1 |
X axis is 100 data points, and all must be displayed. They do display, but are all mushed up. In Corel, you have the option to display the X axis on up to 3 rows, with interspersed tick marks. In Excel, I seem to be able only to manipulate the number of categories between tick ...
|
| Dynamic Range | 08 Mar 2006 17:31 GMT | 2 |
Is there a way to create a Dynamic Range for data that runs through Rows than in Columns? I found several ways to do this by columns however not by rows. Thanks,
|
| Datapoints | 08 Mar 2006 17:31 GMT | 1 |
I have automatically generated datapoints in a chart that show up where I put them, but in Print Preview show up on the top or bottom of the chart . I have already tried to align them via the formatting option. The only time they stay in place is when I make the chart smaller. ...
|