Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Several items here...
- In Excel, when one plots a chart containing a LOT of data with anything other than a solid line, it is impossible to use any other format because the line formatting restarts with EACH DATA POINT. Let's say I have 5 plots I want on one graph. I have a black and white printer. I need to use symbols to differentiate which one is which. But, because each plot has 1000 data points, everything looks the same! It would be better if you could make the line format be scaled according to, say, a percentage of the plot window width. * Dashed lines: the width of the dash is specified as a percentage of the plot width--say 2%...that way you'd always see it, with 10 or 10,000 data points. * Symbols--allow symbols to be plotted as part of the line, rather than only as data points. - Also, the "Tools...Options...Chart Options" route required to change how blank cells are interpreted on the chart ("interpolate", "gaps", or "zero") should be part of the chart options or series options. The feature also doesn't work with multiple data series in one chart. I had two plots on one chart, and both possessed areas where data was missing. Individually, I was able to make them interpolate between gaps. When combined, neither would. I had to wade through 20,000 data points and delete the empty zones for it to work. - Add the ability to put the area under a curve in a scatterplot in as a shaded region. - Add the ability to do a "zoom plot"--this is where I make a chart, and wish to examine one area of it in a breakout window in much higher detail. This could be done through selecting a region to zoom in on, and then having Excel insert a mini-chart into the existing chart. - Add the ability to have items plotted that do not appear in the legend. Thanks, Christian |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem with Chart Title Formatting | Charts and Charting in Excel | |||
Problem with xlusrgal.xls file | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel | |||
Area Chart Formatting Question | Charts and Charting in Excel | |||
Why do my text boxes disappear from my chart when I click out? | Charts and Charting in Excel |