| Thread | Last Post | Replies |
|
| Shade under a line | 04 Nov 2006 00:07 GMT | 1 |
I have scatterplots with date/time along the X axis, and data on the Y axis. I'd like to add shading from sunrise to sunset. I can create a line on the scatterplot that is 0 during the day and a value greater than the max Y value at night, but would like to be able to shade
|
| Charting Time Series Data | 03 Nov 2006 18:09 GMT | 1 |
I want to replicate the graph format shown in the first graph of the following article: [url="http://www.dmreview.com/article_sub.cfm?articleId=1031173"] I think this format would work well for my purposes, though my data is
|
| highlighting different sections of a line chart | 03 Nov 2006 18:09 GMT | 1 |
I have a line graph that runs over time. i would like to highlight certain areas of continuous time with shading of different colour. Is this or something similar possible?
|
| Non Numeric Values | 03 Nov 2006 18:08 GMT | 1 |
I have a list of students with their grades at the end of each year. The grades are alphanumeric - 3C, 4B and so on. I need to make a chart for each student that shows their grades year on year and then with a trend line (?) to predict their ultimate grade.
|
| How to display graph if only mean, SD & median values available? | 03 Nov 2006 17:24 GMT | 2 |
I have a series of discrete items of data comprising mean, SD and median values (no range or actual data series available). I am trying to display each discrete data point graphically (mean, SD and median) but am struggling to do this. I am using latest version of Excel but
|
| removing a text box in a chart | 03 Nov 2006 13:51 GMT | 1 |
I've inserted a text box into a chart but realise i no longer need it. How do you remove it? any help would be great. Oliver
|
| How to delete a line segment? | 03 Nov 2006 09:53 GMT | 7 |
I have a line chart that keeps track of daily values and also monthly totals. At the end of the month the monthly values line takes a steep drop back to an initial value for the first day of the new month. Is there any way to delete this line segment and still use the series as ...
|
| Charts | 02 Nov 2006 23:35 GMT | 4 |
It has been about 2 years from the last time I worked with Excel. At that time I had lots of charts and lots of worksheets tracking units, production and so on. I would have 2 or 3 master sheets that took data from each sheet. So here is my issue. I have made a workbook for ...
|
| Pie of pie charts - how to set up data | 02 Nov 2006 23:01 GMT | 1 |
I'm just trying this kind of pie chart for the first time. Example: I have 408 people in my company 401K. Of these, 38 joined in 2006, the other 370 joined in 2005. Of these 38 - 29 get company match, 9 don't.
|
| Word wrap on the category axis | 02 Nov 2006 20:59 GMT | 2 |
I have a chart where some of the category axis' labels are too long and I would like for them to wrap into two lines. is there a way to do this?
|
| interpolating blank cells | 02 Nov 2006 20:12 GMT | 1 |
I want to graph the data from a table, but I want the charts to interpolate the lines inbetween the "blank" cells. All of the cells have formulas in them because they are pulling the data from another worksheet, but some of them appear blank because there is no data for that ...
|
| Line graph X-axis | 02 Nov 2006 20:08 GMT | 1 |
I am trying to plot the following points on a default line graph: X Y 20.09 25.91 54.19 214.73
|
| Scaling within a chart | 02 Nov 2006 17:53 GMT | 1 |
I have 3 series of data; 1. A total figure (1500-2500) and two series of percentages (0-100%). I would like to show them all on the one chart but the scale sits far too hight to see the percentages and they just look like straight lines. Is it
|
| Resizing the legend | 02 Nov 2006 07:11 GMT | 2 |
I inherited a number of Excel workbooks with charts. I cannot resize the legend because placement has been fixed. Is it possible to change that so I can move and resize the legend freely?
|
| Save Chart as EMF File for Import into Word | 02 Nov 2006 05:35 GMT | 1 |
I've successfully been exporting a series of dynamically generated charts from Excel to GIF (I'm programming in VSTO) using code like: Me.Application.ActiveChart.Export("C:\mygraph.gif","GIF") I now need to export these same charts to EMF or WMF so that they can be
|