Graph Text Relationships with Relative Time X? i want to create a depiction of data sources based on latency and durability, but these are not numeric. Durability Latency Now Week Pay Run Month Qtr Yr Archive Forever Analytic DW------------------------------------------------ Interve... 10 Dec 2009 12:19
Problem with line Chart I have the following data: Date Value 1/07 700 3/07 550 9/07 600 10/07 550 7/08 500 9/08 700 2/09 750 8/09 600 I would like to create a simple line char... 10 Dec 2009 23:25
Where can I get a free gauge chart for excel? I have seen numerous pay sites with gauge charts available, but need a free one for work computer. ... 10 Dec 2009 12:19
SeriesCollection(10).Name = "=""""""NBT""""""" What are all these quotes? With the goal of some VBA later, I am playing with charts and saw this in a recording: ActiveChart.SeriesCollection(10).Name = "=""""""NBT""""""" I was changing the name of a series to a text string of NBT. What is the reason for all the quotes.? FYI. Using a range I selected the cell with the name as ... 10 Dec 2009 11:13
Finding second data point on primary axis of two axis chart Hi I am new to Excel 2007 (moved from Excel 2003). I have a chart with one column on the primary axis and a line on the secondarry axis. I added a second series of data on the primary axis and can't find it. This usued to happend with my previous edition of Excel and was quickly remedied by putting the cu... 9 Dec 2009 18:54
Why won't data hide? Why does hidden data still appear when a chart is generated from a pivot table? How can I make a series disappear when I hide the column in the pivot chart? ... 10 Dec 2009 15:40
Moving locations of major, secondary gridlines Is there a way to change the location of major, secondary vertical gridlines? My data points, associated with the secondary vertical axis, do not fall in the right position on the chart. Rather than falling in the middle of the individual categories on the x-axis they are offset randomly to the right or left. ... 8 Dec 2009 17:35
Add addional data on top of bar chart data How do I add a dotted/shaded stack on top of an existing one. Ex: I have 2 stacks that represent revenue shipped in each of 4 Quarters . Then in the next quarter I have revenue shipped to date. Now I need to add projected revenue to ship on top of the shipped data in this 1 Quarter only. The bottom data... 8 Dec 2009 15:18
Data in secondary axis dizappears when using names Hi there, I'm using Excel 2007 and the problem I'm facing is this: I've created a graph which reads data frrom a simple table. Then I named the rows in that table using the OFFSET formula as I want to plot only the last 10 entries of the table and not the whole table. The names that I've given are, for example,... 8 Dec 2009 00:00
change color of curve line as time changes I have a series of values associated with dates; the values in the past are fact, the values in the future are estimates. When I graph the data, the line is all the same color throughout the series. Is there a way to have the color of the line change as the dates become past, rather than future.... in other... 30 Dec 2009 01:12 |