| Thread | Last Post | Replies |
|
| Excel analysis should do proper histograms inc. bars touching | 23 Jun 2006 06:07 GMT | 3 |
Excel produces a wide range of really useful graphs, with the exception of histograms (and box-and-whiskers are also difficult to do), even in the 2003 version that I use. The Analysis ToolPak produces an apology for a histogram with bars not
|
| X - axis labels | 23 Jun 2006 06:02 GMT | 3 |
I have a chart with years on the x-axis. The data starts with 1983, but I would like the first x-axis label to be 1984 or 1985. How can I do this, without simply getting rid of the 1983 data point? Thanks.
|
| Printing embedded charts in Excel 2007 | 23 Jun 2006 06:00 GMT | 1 |
I'm not sure if this something peculiar to my system or Excel 2007. I'm finding that embedded charts are not printing correctly. They are larger than displayed on screen, even in page layout view, and they are not even close to where i place them on the page.
|
| How do I create a bell graph for standard deviation? | 23 Jun 2006 04:57 GMT | 7 |
I have 15 data points with a predetermined mean. How do I create a bell graph to show the standard deviation lines and all of the data points along the X axis?
|
| bar colour | 22 Jun 2006 20:18 GMT | 1 |
I have created a pivot chart. I change the color of the bar from the default to what I want. However, when i change the selection, ie instead of choosing singapore, i choose Hong Kong, the bar color return back to the default color. Anyway I can fix it to what I want.
|
| How do I create a Gantt Chart in Excel 2003? | 22 Jun 2006 20:16 GMT | 1 |
I vaguely remember being in a training class that showed how to make a Gantt Chart in Excel. Alas, I've lost those notes eons ago. Does anyone know how to create a Gantt chart in Excel?
|
| Excel 2007 Beta Charting Problem/Question | 22 Jun 2006 19:18 GMT | 2 |
I was trying to get an answer out of the Excel tech yesterday but she could not help. In prior versions of Excel you have the ability to drag datapoints on a line chart around. It would either just make a change to that cell ref or if it was a cell that was dependant it would ...
|
| Clickable graphs within excel or some type of add-on? activeX? | 22 Jun 2006 16:51 GMT | 2 |
I'm building a workbook and it would be ideal to maintain a smaller number of graphs (versus hundreds) where if I click on a data element (pie wedge or bar) it would tell excel which element was clicked, so I could use that to
|
| Is it possible to conditionaly format based on the data label? | 22 Jun 2006 16:50 GMT | 3 |
I've been searching this board to find an answer and all the post (so far) are helpful but they don't quite get me to where I need to be. That said... I have a 3d plain Jane bargraph. The data is linked to cells, and I physically change the graph at the begining of every ...
|
| Overlapping Pie Charts | 22 Jun 2006 15:44 GMT | 1 |
Is it possible to have one pie chart of a large radius and then a pie chart with smaller radius placed on top of the larger so the centers of the to pie charts coincide?
|
| Disappearing/Greyed Charts | 22 Jun 2006 14:59 GMT | 2 |
I am putting together a business case model that requires a number of charts/graphs. A few days ago the charts, which I had embedded within the relevant tabs, were no longer visible when clicking on the relevant tab. They appear as grey rectangles until clicked, when the chart ...
|
| hide $ symbol | 22 Jun 2006 14:44 GMT | 1 |
hi,i want to hide currency symbol in cells thanks
|
| automatically updating graphs based upon conditional variables | 22 Jun 2006 13:31 GMT | 2 |
We have patients that have two variables assigned to them based upon results of testing. The variables are numbers between 1-6 and there are always 2 numbers assigned to each patient.
|
| Trendline erases chart name | 21 Jun 2006 23:30 GMT | 1 |
When I add a trendline, the chart name gets changed to "Chart Title." The name can be seen in the Chart Objects drop box, if I scroll down enough. When I add the tendline, I'm leaving the Chart Title box marked as automatic, but it still replaces the name to Chart Title. (The ...
|
| scatered charts | 21 Jun 2006 23:29 GMT | 1 |
How could I use a scatered chart so that it funsction as a linear chart connectingpoints of the series while it still allowes me to use the numerical scale to change the minimum and maximum values, and ranges, etc. On the same topic, if this is possible how do i also add the ...
|