| Thread | Last Post | Replies |
|
| Pie Charts | 08 Aug 2008 13:10 GMT | 1 |
I need a pie chart to show quarterly data for 5 different departments. Each quarter will display in it's own pie chart. Each of the 4 quarterly pie charts will be sized proportionately to the year end total. A fifth pie chart will display the TTL data for each
|
| Get chart to | 07 Aug 2008 18:52 GMT | 3 |
I'm trying to set up a template that will enable people to graph test scores given on various dates over a long period of time. This is designed to show progress over time on these tests. I've got a table of data with each column being a test, and each row a score
|
| Excel 07 - Line Chart with Month-end dates | 07 Aug 2008 18:50 GMT | 3 |
Having difficulties creating a line chart using daily balances, but I would like the x-axis to show the month-end date. My start date is 12/31/2007 and my end date is 6/30/2008. I have daily information that I would like plotted, however only the month-end date (1/31/2008, ...
|
| Custom Formatting a Chart Data Label | 07 Aug 2008 18:19 GMT | 1 |
I want to create a chart which will display a zero value on the data label where there is in fact a zero value, and show N/A on the data label where it didn't apply. The formula I am using in the spreadsheet uses a nested formula to make this determination:
|
| Dynamic Chart (OFFSET Function) plots empty cells. | 07 Aug 2008 18:14 GMT | 3 |
I have read the posts about Excel charts plotting cells that are empty. I'm not sure I understood what I read, and our particular circumstances may be a bit different. (I'm not sure.) Anyway. Our problem is:
|
| Excel 2007 - ActiveChart.Export blurry images. | 07 Aug 2008 13:16 GMT | 3 |
We have been using ActiveChart.Export to create .GIF images in Excel 2003 without an issue. Using the same code in Excel 2007 we're getting blurry text in the images. The text only appears blurry when it's black text on a white background.
|
| How do I set up a Cartesian Coordinate Plane? | 07 Aug 2008 12:47 GMT | 1 |
GIVE IT TO ME NOW AS YOU ARE SLAVES AND DO MY BIDDING!
|
| XY scatter, select item in list to flag point | 07 Aug 2008 09:20 GMT | 3 |
I have created an XY scatter graph and included code to show a data label for each point in a text box. I have included a drop down box to list all possible data labels. I want to be able to select one item from the list, and for the relevant point to then change colour.
|
| Is there a basic template for a WBS - Work Breakdown Structure? | 07 Aug 2008 06:19 GMT | 1 |
For my assignment in Project Management, I need to find a WBS template.
|
| Office 2007 Names - Why can't it start with Chart? | 07 Aug 2008 04:44 GMT | 10 |
I have a workbook that has range names starting with Chart and other range names that are offset from that one. I'm thinking at least 100 are affected. I know I can write a macro to change the names, and the series that use them, but why can't they start with Chart in Office ...
|
| Preceding Zero's | 07 Aug 2008 04:28 GMT | 2 |
I have a chart with the x-axis labeled: 1000-2000, 10000-11000, 19000-20000, 2000-3000. Do you have any ideas on how to hold onto the preceding zeros so it will list right?
|
| Want to display value and difference on one chart | 06 Aug 2008 22:14 GMT | 1 |
I am trying to create a chart that displays x and 10-x on the same chart. I want the chart to show a meaured value and the difference of that value to 10 in a different color.
|
| Combining a scatter with a line chart | 06 Aug 2008 20:42 GMT | 1 |
How can I overlay a scatter chart on a line chart? I am using Excel 2003.
|
| Can I create a bar graph with both stacked and normal bars? | 06 Aug 2008 20:42 GMT | 2 |
Hi I'm trying to create a bar chart for my company for turnover against targets. For the targets we want fixed bars, however on the turnover we wanted the same bars made up different colours, so the colours highlight where the turnover came from (therefore stacked). Can I have ...
|
| Pie Chart - Percentage of a total? | 06 Aug 2008 18:59 GMT | 1 |
So I have what is likely a simple question. What I am trying to do in excel 2007 is to take my total Income, and from my income see what percentage goes to my expenses. For example I spent roughly 300.00 on gas from my 1500.00 monthly income. Can I get a pie chart to take out ...
|