Charts
in [Excel]
|
Remove Connnecting Lines from Line Chart? Help! I want a line chart that only shows data points, not lines in between. A scatter chart doesn't work correctly with the data. How do I remove the connecting lines from a line chart and just show the data points? Help is appreciated! ... 16 Apr 2010 16:14
Selecting a point on a chart in Excel 2007 on Windows 7 Dear Ji Zhou, Ji Zhou wrote... Our managed newsgroup support team still supports the MSDN Subscribers in the managed newsgroup. Just recently, the server has some issues that it cannot pick up the MSDN Subscriber posts. The tool team is now working on this. This is really "good news, bad news" situat... 17 Apr 2010 15:13
how to find values before plot peak? I'm looking for a way to select (even by conditionnal formatting) values from a normal spread plot basing on different criteria before and after the peak value. ... 16 Apr 2010 13:59
GANTT chart - Collapse multiple values, same label on same line? Anyone know if there's a way I can collapse multiple values onto the same line? For example, in my GANTT chart I have the following scenario. The horizontal category is multi-level, Brand + Promotion Name. I'd really like to be able to collapse scenarios where there's multiple records, with the same or diffe... 16 Apr 2010 12:52
Why did the workbook save as a group? I copied text, values and formulas from one workbook to another. When I tried to chart some of the data, the chart insert chices were grayed out. It appears the file was saved as file name [group]. How do I ungroup? ... 16 Apr 2010 02:57
Too hard to do? Good Day, I have to take (certain) data from one sheet to another if a particular cell is not blank dynamically. F400 PROJ 8029 3/18/10 7.25 12 F400 ACT 8029 3/19/10 KF10-0005 EVANS 9 13 F200 PROJ 8726 3/24/10 7.25 10 F200 ACT 8726 3/25/10 KF10-0006 JOCHEN 13 19 D400 PROJ 62 3/12/10 7.25 12 D400 AC... 16 Apr 2010 19:34
Dynamic Chart title and text formula? I have a series of charts that I'd like to create a title for using the left function. I'd like the chart titles to be the result of =LEFT(B7,7). I know how to pull the full contents of a cell but thought of saving a step to avoid doing this as a separate cell formula and point the chart title to that. Any ide... 16 Apr 2010 08:22
Min and Max Value Changes I want to just label and highlight the min and max values in an XY chart and have them move appropriately if the data change. i saw a tutorial on line about doing so in 2003 but I can't get it to work in 2007. -- Dave B ... 26 Apr 2010 11:24
using Access Data I have a slight problem with Charts in Excel & Access. I'm creating charts that can use up to 50,000 data points (if not more) and in Excel there is significant lag time (up to 2 minutes just to rescale an axis or change the title). I decided to try and use Access to organize the data, but creating a chart in... 15 Apr 2010 14:46
Drawing attention to difference in bar chart Hi there I have a pair of financial data I was tracking over 3 years. Now I put them in a bar chart to show both values: I ended up with 3*2 bars, which is great. :) Now I need to highlight the growing difference between each pair over the 3 years. Is there any way I can do that? I don't want to add a 3... 16 Apr 2010 08:22 |