Charts
in [Excel]
|
Problems with Viewing Charts in Excel 2007 We are having major problems with Excel 2007, so I thought I would start with the latest problem, viewing a line chart that was created in Excel 2003. You open the worksheet in compatibility mode and the graph is there, but it displays blank. Can anyone tell me what we need to do to get the graph to display in 07. ... 28 Jun 2008 13:43
conditional formatinf of graph series I have a spreadsheet where the font is colored based on conditional formatting. Is there a way to have the graphed series of these values match the format color. Thank-you Zb ... 28 Jun 2008 13:43
Traffic light problem I am using the camera tool to create a background for a chart so that when the results reach a certain level the surrounding background changes to green, or red if poor results etc The problem i have may seem cosmetic but the picture (camera object) has sharpe corners where rounded would be more desirable for t... 28 Jun 2008 08:36
Using a variable for a chart limit Since I got instant help on my last query, is there any way to use a cell reference as an axis minimum or maximum in format axis? It seems impossible, but there is a lot of experience out there. Thanks in advance. -- Vince F ... 28 Jun 2008 06:34
Not plotting null or text data I am trying to plot data from cells that have a conditional that returns either a null "" (I could also make it text) or numerical data. I wish only to plot the numerical data, but the null (or text) data plots as zero no matter what I do. Since the states of various cells may change, I don't wish to exclude ... 27 Jun 2008 13:11
how can I use a number series with gaps in as a chart axis I have a spreadsheet with samples normally taken on a weekly basis. Rather than plot the data against the week I want to plot it against a running hours figure that is also entered onto the sheet. However if no samples have been taken this leaves a blank and a gap in my line chart for trending and doesn't seem ... 28 Jun 2008 09:37
X Y Scatter Chart - Dates on X axis starting at 1900 Hi, Attempting to create an X Y scatter chart with dates on the X axis, however, when the chart is displayed the dates start at 1/1/1900 instead of 01/15/08. I understand that Excel stores dates and times as a number representing the number of days since 1900-Jan-0, plus a fractional portion of a 24 hour day. ... 27 Jun 2008 11:07
Column/line graph settings "Zb Kornecki" wrote: These solutions are always so simple when you know what they are. My presentation will much better thanks to your help. I appreciate it. Zb While the solution is simple, it is not obvious. Surely this is one of the most basic issues for mixed graphs -- it must have arisen for... 27 Jun 2008 01:55
i can't see a chart i made, all i get is blue worksheet when i make a chart, it will appear in worksheet with original data. when i move to its own chart worksheet, all I get is a blue window. What am i doing wrong? ... 28 Jun 2008 13:43 |