The simplest is to do a PivotChart.
Select your array of dates (with a header) and create a new Pivot Chart (Insert / PivotChart / Ok)
Then on the field list window, drag and drop the date column in the Axis list first and then in the value list first.
Step 1:
Step 2:
Related Contents:
- IF statement: how to leave cell blank if condition is false (“” does not work)
- Insert picture into Excel cell [closed]
- Remove leading or trailing spaces in an entire column of data
- Freezing Row 1 and Column A at the same time
- What is the difference between “Form Controls” and “ActiveX Control” in Excel 2010?
- Ignore Duplicates and Create New List of Unique Values in Excel
- How to use workbook.saveas with automatic Overwrite
- Excel: the Incredible Shrinking and Expanding Controls [closed]
- How to convert a date in Excel to ISO 8601 format
- Check whether a cell contains a substring
- How to keep one variable constant with other one changing with row in excel
- How to get the path of current worksheet in VBA?
- Generating CSV file for Excel, how to have a newline inside a value
- Working with time DURATION, not time of day
- Break out of a While…Wend loop
- Microsoft Excel ActiveX Controls Disabled?
- Parsing an ISO8601 date/time (including TimeZone) in Excel
- Check if the file exists using VBA
- Open Excel file for reading with VBA without display
- Converting unix time into date-time via excel
- Code Golf: Numeric equivalent of an Excel column name
- Prevent cell numbers from incrementing in a formula in Excel
- How do I express “if value is not empty” in the VBA language?
- How to create a GUID in Excel?
- Are ActiveX Controls Disabled?
- Convert xlsx file to csv using batch
- Find the differences between 2 Excel worksheets?
- Excel cell from which a Function is called [duplicate]
- iterate through all rows in specific column openpyxl
- Properly Handling Errors in VBA (Excel)
- “Out of Memory Error (Java)” when using R and XLConnect package
- Loop through each cell in a range of cells when given a Range object
- Why is there still a row limit in Microsoft Excel? [closed]
- vba: get unique values from array
- Excel CSV. file with more than 1,048,576 rows of data
- Excel – Shading entire row based on change of value
- Is VBA an OOP language, and does it support polymorphism?
- Excel Automation with Haskell gives a seg fault
- VBA check if file exists
- What are the RGB codes for the Conditional Formatting ‘Styles’ in Excel? [closed]
- Creating a chart in Excel that ignores #N/A or blank cells
- Are there such things as variables within an Excel formula?
- Border around each cell in a range
- What indicates an Office Open XML Cell contains a Date/Time value?
- In Excel, sum all values in one column in each row where another column is a specific value
- Why MS Excel crashes and closes during Worksheet_Change Sub procedure?
- Is it possible to replace Excel’s VBA Editor/IDE with a modern alternative? [closed]
- Check if value exists in column in VBA
- CSV decimal dot in Excel
- Delete a row in Excel VBA