Streamlining your workflow often involves managing your time effectively, and Excel's calendar selection feature can be a game-changer in this regard. By learning how to set up calendar selection in Excel, you can automate tasks, track deadlines, and plan your schedule with ease. Let's dive into this useful tool and explore its capabilities.

Before we begin, ensure you're using Excel 2010 or later, as the calendar selection feature is not available in earlier versions. Also, make sure you have a date column in your data range, as this is crucial for the calendar selection to work correctly.

Understanding Calendar Selection in Excel
Calendar selection in Excel allows you to pick a date from a drop-down calendar, making data entry more intuitive and user-friendly. It's particularly useful in scenarios where you need to input or validate dates, such as project start and end dates, deadlines, or event scheduling.

Excel's calendar selection feature is essentially a data validation tool that restricts the user's input to a specific date range. It's not a built-in feature but can be created using a combination of Excel's built-in tools and a bit of VBA (Visual Basic for Applications) coding.
Enabling the Calendar Selection Feature

To set up calendar selection in Excel, you'll first need to enable the Developer tab in your ribbon, as this is where the Visual Basic editor is located. Here's how to do it:
1. Right-click on the Ribbon and select 'Customize the Ribbon'.
2. Check the box next to 'Developer' and click 'OK'.

Creating the Calendar Selection Drop-Down
Now that the Developer tab is enabled, you can create the calendar selection drop-down. Here's a step-by-step guide:
1. Click on the 'Developer' tab and then click on 'Visual Basic'.

2. In the Visual Basic Editor, go to 'Insert' > 'Module' to insert a new module.
3. Copy and paste the following VBA code into the module:



![How to Make a Calendar in Excel [Complete Guide + Free Templates] - GeeksforGeeks](https://i.pinimg.com/originals/78/2e/dd/782edd519265541d1f6be8a19c510453.png)
















`Sub DatePicker()
`Dim o As Object
`Set o = CreateObject("Excel.Chart")
`o.ChartType = xlXYScatterLines
`o.ChartStyle = 203
`o.ChartTitle = ""
`o.Axes(xlCategory).TickLabels = Array("Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec")
`o.Axes(xlValue).TickLabels = Array("")
`o.Axes(xlCategory).TickMarkSpacing = 1
`o.Axes(xlCategory).Minimum = 1
`o.Axes(xlCategory).Maximum = 12
`o.Axes(xlValue).Minimum = 1
`o.Axes(xlValue).Maximum = 31
`o.Axes(xlValue).TickLabels = Array("1", "2", "3", "4", "5", "6", "7", "8", "9", "10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20", "21", "22", "23", "24", "25", "26", "27", "28", "29", "30", "31")
`o.Axes(xlValue).TickMarkSpacing = 1
`o.PlotArea.ClearFormats
`o.PlotArea.Fill.ForwardApply
`o.PlotArea.Fill.Solid
`o.PlotArea.Fill.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Fill.Transparency = 0
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255, 255)
`o.PlotArea.Line.Weight = 0
`o.PlotArea.Line.Transparency = 0
`o.PlotArea.Line.ForeColor.RGB = RGB(255, 255,