Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Showing SeriesCollecion as a Spot with value
Hi,
Through a VB Program, I need to show the SeriesCollection as a dot with its value (no columns or continuous lines). How do I accomplish this? Would appreciate an early reply. Thanks Sugith |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Showing SeriesCollecion as a Spot with value
Sugith,
Turn on the macro recorder. Select the column or line. Click the Format menu Select "Selected Data Series" Set the Line to None (If you want the dot, than you need to use a line chart.) Set Data Label to Show Value Turn off the recorder. Now edit the macro. -- sb "Sugith Kumar" wrote in message ... Hi, Through a VB Program, I need to show the SeriesCollection as a dot with its value (no columns or continuous lines). How do I accomplish this? Would appreciate an early reply. Thanks Sugith |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Showing SeriesCollecion as a Spot with value
Turn on the macro recorder and see if you can make the changes manually that
will give you want you want. If so, then the recorded code should give you the general syntax. -- Regards, Tom Ogilvy Sugith Kumar wrote in message ... Hi, Through a VB Program, I need to show the SeriesCollection as a dot with its value (no columns or continuous lines). How do I accomplish this? Would appreciate an early reply. Thanks Sugith |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Showing SeriesCollecion as a Spot with value
Thanks Tom/Steve for the reply.
But how do we do this thru VB code? Any examples? Thanks Sugith -----Original Message----- Sugith, Turn on the macro recorder. Select the column or line. Click the Format menu Select "Selected Data Series" Set the Line to None (If you want the dot, than you need to use a line chart.) Set Data Label to Show Value Turn off the recorder. Now edit the macro. -- sb "Sugith Kumar" wrote in message ... Hi, Through a VB Program, I need to show the SeriesCollection as a dot with its value (no columns or continuous lines). How do I accomplish this? Would appreciate an early reply. Thanks Sugith . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Showing SeriesCollecion as a Spot with value
Sugith,
Here is some code that I got using the macro recorder. Below it is a more streamlined code made by eliminating code lines not neeed. ================================================= Sub Macro1() ' ' Macro1 Macro ' Macro recorded 9/22/2003 by Sbell ' ' ActiveSheet.ChartObjects("Chart 1").Activate ActiveChart.SeriesCollection(1).Select With Selection.Border .Weight = xlThin .LineStyle = xlNone End With With Selection .MarkerBackgroundColorIndex = xlAutomatic .MarkerForegroundColorIndex = xlAutomatic .MarkerStyle = xlAutomatic .Smooth = False .MarkerSize = 5 .Shadow = False End With ActiveChart.SeriesCollection(1).ApplyDataLabels Type:=xlDataLabelsShowValue, _ AutoText:=True, LegendKey:=False End Sub ============================================= Sub Macro1() ' ' Macro1 Macro ' Macro recorded 9/22/2003 by Sbell ' ActiveSheet.ChartObjects("Chart 1").Activate ActiveChart.SeriesCollection(1).Select With Selection.Border .LineStyle = xlNone End With ActiveChart.SeriesCollection(1).ApplyDataLabels Type:=xlDataLabelsShowValue, _ AutoText:=True, LegendKey:=False End Sub =============================================== -- sb "sugith kumar" wrote in message ... Thanks Tom/Steve for the reply. But how do we do this thru VB code? Any examples? Thanks Sugith -----Original Message----- Sugith, Turn on the macro recorder. Select the column or line. Click the Format menu Select "Selected Data Series" Set the Line to None (If you want the dot, than you need to use a line chart.) Set Data Label to Show Value Turn off the recorder. Now edit the macro. -- sb "Sugith Kumar" wrote in message ... Hi, Through a VB Program, I need to show the SeriesCollection as a dot with its value (no columns or continuous lines). How do I accomplish this? Would appreciate an early reply. Thanks Sugith . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
X marks the spot | Excel Discussion (Misc queries) | |||
Dead spot in worksheet | Excel Discussion (Misc queries) | |||
Hosur an IT hot spot? | Excel Worksheet Functions | |||
2 printers 1 does not print name in same spot | Excel Discussion (Misc queries) | |||
I want a name in one spot and it's code in another | Excel Discussion (Misc queries) |