| Thread | Last Post | Replies |
|
| How do I change x-axis in an Excel Radar Chart? | 07 Oct 2005 16:02 GMT | 1 |
I would like to plot a radar chart with 360 points however the excel radar assigns a line for each point, I would like to reduce this to 1 line every 10 degrees. Is this possible? Ideally I would like a polar plot graph where I can enter any angle and
|
| how to hide zero values on line chart | 07 Oct 2005 13:59 GMT | 2 |
in EXCEL - I want to have line chart showing Planned vs Actual over time (weekly). I have 5 data points for Planned. I want to show Actual results only when there are non-zero values. Details: the Actual data series is a count of data entered. For example, at
|
| log scale shading | 07 Oct 2005 05:17 GMT | 2 |
Any ideas how one can shade above or below an xy-scatter chart; when the chart is semi-log (suppose easier) or log-log scaled? Cheers tom
|
| how to create a chart in excel with data from another workbook | 07 Oct 2005 04:57 GMT | 2 |
Can you please tell me how i can create a chart in one workbook using data from anothe workbook. I also want to link this chart to the table so it gets updated automatically
|
| Scatter chart with columns instead of points | 07 Oct 2005 04:53 GMT | 1 |
I need to create a chart showing the number of students who received each numerical grade on test. The spacing between grades is not equidistant (ex: 65, 70, 90, etc.) and I need to show the true spacing on the x-axis. So I chose a scatter chart because the other charts make ...
|
| XY Scatter with Custom Labels | 07 Oct 2005 04:49 GMT | 1 |
I have a list of products, each with an X (a dollar amount) and a value (a percentage). Is it possible to have each point labeled with custom value i.e.: Printer, or Digital Camera, rather than it bein labeled with just the values being plotted ($1,000, 2% or $500, 7%)?
|
| Multi data charts | 06 Oct 2005 18:27 GMT | 3 |
I want to build a chart which shows the year on the horizontal axis and the totals on the vertical axis. The tough part is there are six diiferent data series for each year that when summed give the total for the year. I want to show one bar for each year with each individual ...
|
| How do i add a line graph onto a stacked column chart using data | 06 Oct 2005 16:03 GMT | 1 |
I have a stacked colum chart showing the make up of total with 3 variables I need to then add a line overlaying this showing expenditure and have no idea how to do this- can anyone help I can'tfind it in general help
|
| where can i find an expense account form | 06 Oct 2005 15:17 GMT | 1 |
I need a simple expense account form that we can use in our company for recording weekly expenses. A form that will calculate the mileage into dollars based on government allowable cost per mile, etc.
|
| Line Graph Problem | 06 Oct 2005 14:06 GMT | 2 |
Hello - I am having a problem with a line graph I have. Basically the line graph is populated on a month to month basis, from protected cells that contain formulas. This is an example of the formula for each month: =IF(J35 =
|
| Summarizing by Time | 06 Oct 2005 13:39 GMT | 2 |
My data is a table of times, server names, and error counts. The time stamps are by the second. I need to chart this as a summary of total errors in 15-minute intervals. Then, I would like if at all possible for the chart time to list only the hours. Any ideas on to do this?
|
| Draw Objects in Charts | 06 Oct 2005 13:33 GMT | 2 |
I have a Workbook where I enter my Blood Pressure on a daily basis and plot it on an X-Y chart over time. The chart automatically expands the X-axis as new data is entered. I recently changed medication and placed a draw object
|
| View Header/Footer in Charts | 06 Oct 2005 10:33 GMT | 1 |
I added a footer to my chart, but it only displays when I print it or in Page Setup. Is there a way to view it in normal view?
|
| Can't make secondary axis in bar chart | 06 Oct 2005 09:21 GMT | 2 |
I've read several postings regarding adding a secondary axis to a bar chart, but I am having a problem. When I select the data series I want to plot on a secondary axis, the "Axis" tab does not come up, just Patterns, Shape, Data Labels, Series Order and Options. I can get it
|
| How do you make a combination chart with 2 axis. | 06 Oct 2005 00:28 GMT | 1 |
I'm tring to plot 2 kinds of data. 1 is a % and the 2 is a quanity. How do I put both on same chart?
|