| Thread | Last Post | Replies |
|
| Is is me? Or is Excel 2007 Charting Lame? | 13 Jan 2008 23:54 GMT | 13 |
Maybe I'm missing something. If so, let me know. The process of creating a chart is unintuitive and cumbersome. A big step backwards from 2003. The manual says to just select your data and insert the chart. What I find is that 95% of the time, I have to
|
| Concatenate in chart titles | 13 Jan 2008 20:49 GMT | 4 |
I am trying to have my chart titles auto populate with both text and a reference field. I want the title text box to read "Text 'contents of a referenced cell'". Is this possible? I can have the title text box display contents of a referenced cell, but cannot add text to the ...
|
| Flexibly specifying data series in charts | 13 Jan 2008 15:38 GMT | 3 |
I have tables with many columns. I want to create a chart that will allow me to specify which columns to use for x- and y-axes, preferably with two pull-down menus. Basically, I want to avoid the present situation where I create a new chart every time I want to observe the ...
|
| Inporting JPEGs | 13 Jan 2008 15:35 GMT | 1 |
OK.... I'm old and not as fast as the rest... I need some help in importing a JPEG into an EXCEL sub-field and have it retain the size of the field.
|
| Plot area not printing correctly | 13 Jan 2008 03:40 GMT | 3 |
I have a worksheet with several charts on it. The charts look fine on my screen. When I "Print Preview" the page, some of the plot areas on the sheet are shrinking. The chart area appears to be the correct size, but the plot area is shrinking to the top of the chart area, ...
|
| Conditional Formatting for Charts | 13 Jan 2008 01:50 GMT | 3 |
I understand the concept of conditional formatting in spreadsheets in XL 2003 just fine. Can the same functionality be extened to XL Charts? I am thinking it has to be a VBA solution, which is not a problem. I just wanted a
|
| How do I setup a "Thermometer" graph? | 12 Jan 2008 17:08 GMT | 1 |
I would like to set up thermometer graph similar to those used for fund drives. This would be used in a manufacturing plant to show employees how far we need to go to reach our monthly sales goal. I'm using MS Excel 2003.
|
| How do I use 2 sets of data in a chart | 12 Jan 2008 13:14 GMT | 1 |
both sets of data are in the same workbook, but on two different worksheets.
|
| Dates appear wrong in my chart | 11 Jan 2008 23:46 GMT | 1 |
I have a bar chart I have created from a table. I want the x axis to be the dates shown in the table. currently 11/01/2007, 11/01/2006, etc. They appear in the chart as 01/01/2007, 01/01/2006, etc. If I change the formatting in the chart from date to number than the dates in ...
|
| how can I show 0 values in a pivot chart? | 11 Jan 2008 19:19 GMT | 2 |
I want to see 0 values on my pivot table, ie: 10 8 6 x
|
| Create vertical line to indicate date on chart with series of date | 11 Jan 2008 18:36 GMT | 1 |
I am trying to figure out a way to add a vertical line to a chart that shows a range of dates on the horizontal axis. I think a vertical line, interesting with a particular date. I will most likely use =today() for the vertical line. How can this be done?
|
| global formatting of legend keys | 11 Jan 2008 12:32 GMT | 7 |
In a chart i have multiple legend keys, as a result all colors are not visible because the columns are thin and border line black, thus i can see only black columns. i can format each key manually but if i have 200 keys it would never end, how can change the border option from ...
|
| Error with chart | 10 Jan 2008 23:33 GMT | 2 |
I am trying to produce achat and i get series format is too long what does this mean ?? Thanks
|
| Removing weekend/holiday dates - cont'd | 10 Jan 2008 21:09 GMT | 4 |
Sorry but I must be missing something. I'm with you until "Axis Options", but under "Axis Options" I don't see anything that says "Axis Type" or anything that gives me the option to have a text axis. Thanks p.s. I am using a scatter chart
|
| Were can I attach a file to respond to a question | 10 Jan 2008 21:07 GMT | 2 |
Yeasterday I asked how do I attach a file for a user to see a same of a solution and I recieved the answer - use a free web service. I see my question needed to be more specific. Could someone please give me instructions on where and how to do this.
|