| Thread | Last Post | Replies |
|
| Hide Cells with Zero Value in Excel 2007 while using line chart ty | 23 Jan 2008 20:52 GMT | 1 |
I am using Excel 2007 and have a situation with the charting functionality. For example - I am trying to set up automatic update chart update for Jan 08 – Dec 08 data i.e. user just enters data each month and the graph trend shows up each month. I have done this a lot of times ...
|
| I'm building a stacked line chart. | 23 Jan 2008 20:49 GMT | 1 |
I'm building a stacked line chart, with three lines: minimum acceptable value, maximim acceptable value, and measured value. For all values along the x-axis, the min and max are the same (horizontal line). If I use a single cell for the max or min value, the chart builder only ...
|
| Excel charts | 23 Jan 2008 19:36 GMT | 2 |
Hi is it possible to plot 3-axis (x,y,z) charts in Excel?
|
| Update and sort chart from drop down change | 23 Jan 2008 14:36 GMT | 2 |
Hello Excel gods, I come to your mountain seeking wisdom. I have a bar chart with 12 categories that are referenced from a data table, and that data is filterd from 3 drop downs. I have the chart set up now that the chart data and graphics update as the drop downs are changed, but ...
|
| Changing order of series in line-column chart | 23 Jan 2008 12:32 GMT | 1 |
Using Excel 2003. Plotting a line-column chart using two columns of data "Actual" & "Target". How can I change the order of the series, so that the bar becomes the line and the line becomes the bar, without changing the location of the data?
|
| Changing order of series | 23 Jan 2008 12:32 GMT | 2 |
I am using a line/column chart, Excel 2003, to plot two values (actual vs. goal). I would like to change the order of the data series in the chart (change the bar to line and the line to bar). Excel help says to click on the data series, “Format”, “Selected Data
|
| Chart Axis | 23 Jan 2008 12:30 GMT | 7 |
Using Excel 2003 I am charting some data that has a large range in numbers. I'm using a clustered column chart that compares values across categories. The chart has 4 categories of numbers to chart monthly. The problem I'm
|
| How do i customise the plot area of a graph? | 23 Jan 2008 10:42 GMT | 1 |
In 2003 i customised a graph where the first 10% of the plot area was coloured red, 10% to 80% amber and thent he rest green. This doesnt have to be conditional but i cant find out how to do it in 2007. Any ideas ?
|
| Analysing time and days patterns in a chart | 23 Jan 2008 10:29 GMT | 2 |
What do you think would be best chart format to analyse some data that consists of: Date of Call out Day of call out
|
| How to check the condition before the chart is being plotted? | 23 Jan 2008 02:03 GMT | 3 |
How to check the condition before the chart is being ploted? For example: I need to check the value in the cell “A1”. if the value in the cell A1 is “1” , I need to plot the chart data that is present in the column B1 to
|
| Chart Area visible but cannot access rows and columns on worksheet | 23 Jan 2008 01:57 GMT | 2 |
I have a graph in an Excel spreadsheet and the entire area of the graph are all gray. The row and column heading are not visible - the entire area around the chart is grey. If I am in a preview mode I can't change it because the option to select Normal or Page Break Preview is ...
|
| Macro Copy Excel Chart Sheet to PowePoint - Mod of Jon Peltier code | 22 Jan 2008 00:26 GMT | 6 |
Jon Peltier wrote a great macro to copy an Excel Chart on a worksheet (not a chart sheet) to an open PowerPoint presentation. I had need of a slightly different version and modified the code to the state below to a) work with a Chart sheet and b) preserve the size of the title ...
|
| Bar Chart with Secondary Line | 21 Jan 2008 19:30 GMT | 1 |
I'm creating a bar chart that I need to put a secondary axis (line chart) on. The bar chart is vertical and the line chart is horizontal. How can I get the secondary line chart to run vertically with the bar chart??
|
| Named data series won't dispay in Excel 2007 | 21 Jan 2008 17:54 GMT | 4 |
A file created with Excel 2000 contains a chart with a dynamic, named data series. I emailed the workbook file to a colleague who uses Excel 2007. When he opens the file, the data series simply doesn't display. When I examine (in E-2007) the chart's source data, Excel tells me ...
|
| bar charts don't udate when data is changed-why? | 21 Jan 2008 16:38 GMT | 3 |
I inherited a spreadsheet with data on sheet 1 and an Excel-generated bar chart on sheet 2. The table is NOT a pivot table. When I change data in the table, the bar chart never updates. I am relatively new to Excel. What am I missing?
|