| Thread | Last Post | Replies |
|
| how to prevent Excel from reformatting a chart wen updating data? | 10 Feb 2006 14:47 GMT | 3 |
I have data over time for different categories. when i change de reporting time frame i want the chart colors to stay the same. Or when i change the scope in categories i still want the categorie chart to keep its color. How to stop excel from reformatting the colors?
|
| Scratter Plot Problem | 10 Feb 2006 10:21 GMT | 1 |
Hello, I am facing a problem about charting in Excel. I have a table as below rank name Xvalue Yvalue 1 Aron 10 20
|
| Not Displaying Zero Values | 10 Feb 2006 10:17 GMT | 1 |
Hello, I have a pie chart being created based on the value of a series of rows. Since some of the cells within these rows are zero, I would like the chart to populate based on the values that are greater than zero. I thought I could address it by writing a formula to only show a ...
|
| Forecasting | 10 Feb 2006 10:15 GMT | 1 |
I am graphing a straight line. For the first part (6 months) I want to use the actual figures and for the second 6 months I want to use a forecast. Is there some way on excel that I can have the first 6 months as a full line line, and have the second 6 months as dot points?
|
| Copy and paste Excel chart in Word --> font compresses | 10 Feb 2006 03:25 GMT | 3 |
A coworker and I are having problems with some Excel charts she pastes into a Word document. Any Excel chart she pastes will appear with all text compressed--an Arial font *looks* like Arial Narrow, except that the character spacing matches the spacing of the normal Arial font, ...
|
| quadrant (perceptual) maps in Excel | 09 Feb 2006 19:04 GMT | 2 |
I was wondering if you could create a perceptual map (graph) in Excel. If yes, how can I do that. I think, XY (Scatter) can be used. Thank you. Vilma
|
| Excel should STOP the "zero or negative ..in log plot" error msg | 09 Feb 2006 18:33 GMT | 1 |
Is there anyway to make the "zero and negative numbers cannot be plotted in log plots..." error message? It is really annoying as it goes off every 5 seconds when a plot has numbers like that. When dealing with big databases it is not a big deal to have zeros in it and still ...
|
| How Do I create a table in excel that shows frequency? | 09 Feb 2006 17:14 GMT | 1 |
Working on an assignment for school and I can't find the right function/table to show me how to create a table showing frequency and relative frequency.
|
| Need to create chart from data in 2 columns and not sure how. | 09 Feb 2006 15:07 GMT | 3 |
I have two columns of data that I want to compare. Here is an example of how they look. Tone Depth
|
| stacked column chart across multiple columns | 09 Feb 2006 14:58 GMT | 3 |
This is totally random, but I would like to know if the folowing would be possible: I have scrap and rework data from three assembly lines - A, B and C. Until now, I've been creating stacked column charts seperately one for
|
| Bar Charts in Excel | 09 Feb 2006 09:13 GMT | 1 |
I am creating basic bar charts in excel and only a few of my data labels on the x axis are displaying. There is plenty of room between the tick marks, but it is just picking up some of the data from the worksheet.
|
| Data labels out of reach | 09 Feb 2006 09:06 GMT | 3 |
I have a chart with data labels "outside end" but one of the bars is too high so It doesn't fit my scale and that label is not displayed. So I increase the scale to find the label, and manually drag it below my chart's previous max value. Then I change the scale back but then the ...
|
| Date formatting in Pivot Chart | 09 Feb 2006 01:36 GMT | 3 |
I'm trying to create a pivot chart and the date field is not formatting properly - the format comes out different from that of the pivot table. How can I fix this? Format axis doesn't give me an option for date format.
|
| Chart doesn't show in Word | 08 Feb 2006 23:55 GMT | 2 |
This is perplexing. When I copy an excel chart and paste it into a word document, the charts technically do paste but do not show the chart. The chart is blank. This happens regardless of how I paste it (if I use the paste special options both chart object and picture don't ...
|
| Excel x,y chart type x range must be re-entered each series | 08 Feb 2006 23:23 GMT | 1 |
In Excel x,y type charts, the x range must be re-entered for each series if the data range is beyond the complexity supported. Please consider a sub-type for graphs where all of the x ranges are the same. Also, consider making the data range feature have options for using the ...
|