| Thread | Last Post | Replies |
|
| Displaying series on top of eachother | 31 Aug 2008 23:12 GMT | 1 |
I have a set of data I have bar charted. 2 of the 4 series actually have a range of X-y. How can I show this in the chart whereby the 2 series show in the same location but the increase is lighter or whatever.
|
| log log charts in excel | 31 Aug 2008 13:36 GMT | 4 |
Can somebody please advise me how I may chart data using log scales on either or both axes? Thanks
|
| How to save an Excel 2007 Chart as a xml File. | 30 Aug 2008 18:31 GMT | 2 |
I have a Excel 2007 file. It has a data source and a chart on the same worksheet. I would like to save this file as a xml file. The problem is not saving the file as xml but once the xml file is created excel is only creating a xml file with the data and NOT to chart. Can excel ...
|
| how to create a line-chart with 2 sets of data who has different x | 30 Aug 2008 15:55 GMT | 1 |
hi, i don't know how to create a line-chart with 2 sets of data, they have different size. Say set_1 has x-axe from 0 - 12 with 150 intervals. Set_2 has x-axe from 0-14 with 130 intervals. How to put them into a single line chart?
|
| Horizontal Axis Options Changing | 30 Aug 2008 12:28 GMT | 6 |
Excel 2007 I have noticed that the horizontal Axis options can change in an Excel 2007 chart, which is driving me crazy. On some charts when I open the horizontal axis options, under Axis options, they start out with "Interval between tick
|
| Chart Variables | 30 Aug 2008 11:19 GMT | 2 |
I am using Excel 2003. I'm using "Option Explicit" to force variable declaration. I want to tie the axes of a chart that I have named "MyChart" to worksheet cells. I've been working with the following but continue to get errors:
|
| standard deviation graph | 29 Aug 2008 19:35 GMT | 1 |
I have values that are produced every 3 minutes. I have calculated the standard deviation of those values for each hour for a 7 month span. That is 5115 records. How do I make a bell shaped curve with these values?
|
| not able to see tick mark label | 29 Aug 2008 02:22 GMT | 4 |
I created a custom date-axis in the form N, D, J-YY, F,... But -YY is not always visible even after I have shrunk the size of the tick mark label. Any suggestions would be greatly appreciated.
|
| Show average line by series on a line chart | 28 Aug 2008 16:42 GMT | 1 |
I have a line chart to show actual percentages by month for three different values I am tracking, I would like to show the average for each item as well on this chart as a line across the chart so that for each month one can see if the actual percent is above or below the average ...
|
| Anyone using a thermometer to illustrate results (e.g. sales)? | 28 Aug 2008 11:31 GMT | 1 |
I would like to create a chart in excel that looks like a thermometer which shows progress being made towards a goal. How is this done?
|
| Zero Values on a Pie Chart | 28 Aug 2008 04:48 GMT | 2 |
Hi Everyone! I am doing a pie chart and I can't seem to get the chart to NOT display "zero" values on the pie. I have tried everything and still cannot get it to not display it. I went to 'Tools' then 'Options' then to 'Chart', where it says "Plot empty cells as:" it is gray and ...
|
| Changes to Plot area color | 28 Aug 2008 02:28 GMT | 3 |
I created at template in which the plot area color is bright yellow and applied to a chart. When I re-opened the file the color turned to magenta. I've had other problems with cell colors changing on their own also. Any ideas?
|
| Charting information from nultiple work books | 27 Aug 2008 22:29 GMT | 3 |
I have 4 different workbooks of information, with 12 (1 per month) tabs in each workbook. On each tab I have about 40 lines of information that need to be graphed. I am having great difficulty doing this. I am relatively new to excel, so it's a little over whelming. Each tab ...
|
| secondary Y axis | 27 Aug 2008 21:20 GMT | 1 |
I am trying to write a macro for two y axises. Left side is english (pounds per cubic foot) and the right is metric. What I have now will allow me to graph the english with no problem but when I try to add a second y axis I then don't get any points on the graph. Can anyone ...
|
| How do I refresh pivot table/charts with new data? | 27 Aug 2008 21:15 GMT | 2 |
I am working in Excel 2007 and when I update my source data, charts in other sheets do not get updated.
|