Data in a Chart

Posted by Aaron on January 08, 2002 3:30 PM

I have a chart that has 4 Data sets. 3 of the sets I want the graph to show, and the 4th I don't. However, I want all 4 data sets in the Data Table below the graph. Does anyone have a quick fix? Thanks for all of Your help. -asa

Posted by Bariloche on January 08, 2002 8:13 PM

Aaron,

Assuming you are graphing lines, just format this particular series so that the line format is "None".

enjoy

Posted by Aaron on January 10, 2002 9:09 AM

Thanks, Please forgive my ignorance

This is better

Sub Pretty_Average()

If Range("j1") &LT;&GT; "" Then
Range("j1").Select
If Range("j2") &LT;&GT; "" Then
Range(Selection, Selection.End(xlDown)).Select
End If
ActiveWorkbook.Names.Add Name:="Money", RefersToR1C1:=Selection
Range("j1").Select
If Range("j2") &LT;&GT; "" Then
Selection.End(xlDown).Select
End If
Selection.Offset(1, 0).Select
ActiveCell.FormulaR1C1 = "=average(Money)"
Selection.Copy
Selection.PasteSpecial Paste:=xlValues
Application.CutCopyMode = False
Selection.Font.Bold = False
ActiveWorkbook.Names("Money").Delete
Range("a1").Select
Else: Range("a1").Select
MsgBox prompt:="Looks like someone forgot the data...Show me the Data.", _
title:="Oops..."
End If
End Sub

Cheers!