| Thread | Last Post | Replies |
|
| plotting column charts by variable | 31 May 2006 16:50 GMT | 2 |
I have some data I need to plot in a column chart The variable activeE6 has three columns that show small (49%) med (33%) and large (19%) The variable controlE6 has three columns that show small (29%) med (58%) and
|
| Change 1 gridline | 31 May 2006 15:09 GMT | 8 |
This is probably a very easy question I just haven't spent a lot of time with Excel charts. How do you change the style of 1 gridline on a chart? The data on the Y axis is from -2 to 6 and we would like the line at 0
|
| Edit colour of one gridline in a 3D chart | 31 May 2006 12:54 GMT | 1 |
How can one gridline be edited to change colour in ad 3d bar chart. Thanks in advance for your help.
|
| how do I define a chart series with an indirect reference | 31 May 2006 10:52 GMT | 4 |
I've made a XY scattergram that I want to copy for use to other workbooks with other data series. The exact part of the data series to be displayed in the chart varies between workbooks. In the data series for the chart, I'd like to include an indirect reference that will define ...
|
| formatting of multiple lines on a chart | 31 May 2006 09:41 GMT | 1 |
Hi, I have an ordinary Excel line chart, but there are 30 data series on it. Is there a quick way to format each line the same, eg blue with no individual data points. thanks
|
| Excel 2007 Charting causes blank screen | 31 May 2006 01:34 GMT | 5 |
When I create a chart in Excel 2007 that is its own sheet, I cannot view it. As soon as I move my mouse over top of it my entire screen goes entirely blank. It isn't locked up, just the entire screen goes white. I can still access the keyboard hotkeys and close excel.
|
| Add value of a trendline | 31 May 2006 00:39 GMT | 1 |
I have a graph of the revenue for the last 24 months. I added a trendline to give me the next months. Can I get the exact value of the those trends for the next 6 months?
|
| Pivot Chart Formats | 30 May 2006 22:55 GMT | 1 |
Does anyone know a way to freeze pivot chart FORMAT, while allowing data updates?
|
| Followup:Add vertical line at intersection of 2 curves (Ping Andy Pope) | 30 May 2006 20:28 GMT | 2 |
Okay, I've been hammering away at this for days now, and I *still* just do not get it. I've been _trying_ to use the user-defined function created by Andy Pope (http://www.andypope.info/charts/intersection.htm) to find all the intersecting points of 2 "lines" (actually xy ...
|
| custom number | 30 May 2006 20:07 GMT | 2 |
In order to adjust the spacing of a scatterplot line away from the Y axis, I use a custom number format (applied to the axis) to hide the first (nonploted) year on the X-axis scale.
|
| Excel Charts X Axis values as dd/mm/yy hh:mm | 30 May 2006 15:09 GMT | 1 |
I have a table with readings taken at irregular intervals. I want the data points to be plotted along a continuous axis but when I try to do this all the data appears against the date only and the time is ignored. I have tried setting the x axis as time series but this doesn't work ...
|
| interpolate from chart | 30 May 2006 12:30 GMT | 1 |
I have a chart (x,y). i want to interpolate xnew value from this chart. can you help me? thanks!
|
| Pie Charting with Missing and Changing Data | 30 May 2006 10:46 GMT | 5 |
I am trying to create a dynamic pie chart (has to be a pie chart) that can automatically take into account the fact that the number of series to be graphed each time changes, and that there may be missing data within the list of data
|
| Progress to a Target | 30 May 2006 06:28 GMT | 1 |
I am attempting to create a chart that measures actual progress against expected progress. On the x axis I need each month, and then a single bar that has two series plotted with "current value" and "expected value". Basically as
|
| Custom error bars excel 2007 | 30 May 2006 02:21 GMT | 2 |
I cannot seem to get custom error bars to work on charts in excel 2007. I have a set of data, eight numerical y values, and each one has a different standard deviation. I plot a histogram and use custom error bars selecting +/- my deviations from the worksheet (which are approx ...
|