AJP Excel Information

Newsgroups

My solutions to specific questions posted on the newsgroups. Allowing the original poster and anybody else interested to download files.

Re: Data labels linked to filtered data
Re: Intersection between a line and multiple semi circle curve
Re: Show mean as a vertical line in a graph? (MS Graph)
Re: Yes No count using named range
Re: Kite chart
Re: Point and Bar chart MSGraph
Re: Complex xy scatter MSGraph
Re: Colour line sections
Re: Horizontal Hi-Low chart in Powerpoint
Re: Replace axis text with graphics on excel chart (excel 2003)
Re: Can I link timeline labels to a line chart?
Re: Goal range in a graph
Re: Dotted line for future data
Re: Soft edges
Re: Graph - axis switching for a line graph
Re: How do I change the bar chart to scatter format?
Re: Changing X-Axis Labeling
Re: Label base of 3d column chart
Re: OHLC axis labels
Re: Datum line and split series
Re: Radar chart & labels
Re: Order of labels in the legend
Re: Conditional formatting of text
Re: Setting the radius of a pie chart
Re: How to vary color in an area chart between negative or positive
Re: Colors of columns after sorting data in the supporting table
Re: Dynamic trend line
Re: Broken axis for MS Graph
Re: Clustered stacked dual axis chart
Re: Stacked cluster chart in PowerPoint
Re: Displaying 2 straight lines
Re: Focus / Targeting Lines on a Chart
Re: How to add line at today's date in chart
Re: Bar chart with
Re: Pie in pie, but how to NOT show the sub-pie?
Re: Shade area between lines
Re: Dynamically stacking columns by contribution %
Re: How do I re-position chart data labels?
Re: Single out x-axis value
Re: End label only
Re: Macro to Add Labels to Points in XY (Scatter) or Bubble Charts
Re: Chart with two text axis
Re: Connector lines from chart labels to chart point
Re: Add Data To Table But Not Chart Area
Re: USA Interactive Map Application
Re: Help with Gantt chart - adding a custom axis
Re: XY Line chart
Re: Venn diagrams
Re: Point-and-figure (type of stock market chart) in Excel
Re: Bar chart question. Broken value axis on column chart
Re: Band or ribbon?
Re: How to determine when data is out of bounds on a chart?
Re: Radar - Y axe distribution
Re: conditional chart formatting: specific colors
Re: Population pyramid with reference line

If I feel the solution would benefit a wider audience I may upgrade the solution in to a worked example. 

New users of the newsgroups should check out Chip Pearson's notes for new posters.
http://www.cpearson.com/excel/newposte.htm

last updated 29th September 2007