I have created a macro for one of my users that generates a filled radar chart. I want to display the Format Data Series dialog at the end of the process so that he can reorder the series in the chart to display appropriately but I can't seem to find the appropriate dialog constant. Can anyone help me out?
To select it manually by the way you create your radar chart, select one of the series, right click and choose format data series. The tab I would like to show is Series Order.
I should admit I am using Excel 2002 (Office XP I know, I know....)
Thanks in advance
try this, the argument is the index number of the chart
Code:application.Dialogs(xlDialogSeriesOrder).Show activesheet.chartobjects.count
Perfect - thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks