How to Create Sunrise Chart in Excel Spreadsheet?
Tags: tocreatesunrisechart
Published: 2021-08-19 04:52:47

---
title: How to Create Sunrise Chart in Excel Spreadsheet?
published: true
date: 2021-08-12 17:01:45 UTC
tags: ToCreateSunriseChart
canonical_url: https://geekexcel.com/how-to-create-sunrise-chart-in-excel-spreadsheet/
---

In this article, we will guide you to learn the simple and useful steps to **Create Sunrise Chart In Excel Spreadsheet**. Let’s get started!! Get an official version of MS Excel from the following link:**[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

## Insert Data

- Firstly, you have to **enter the data** in the Excel spreadsheet.
- For instance, we have created the sample **average sunset and sunrise time**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Sunrise-details-1.png)<figcaption>Sunrise and Sunset details</figcaption>

- Then, you have to **create a daylight hours** column in the table.
- For that, you need to **subtract sunrise**  **time** from **sunset time**.

```
Daylight hours = Sunset time - Sunrise Time
```

- Now, by using the **above formula** , you have to write this in **D2** and **copy it down the cells**.

```
D4=C2-B2
```

![](https://geekexcel.com/wp-content/uploads/2021/08/Create-daylight-hours.png)<figcaption>Create Daylight hours</figcaption>

- After that, you have to **calculate evening hours** , by **subtract sunset time from 1.**
- If, you **subtract the sunset time from 1,** then the **remaining time is evening hours**.

```
Evening hours = 1- Sunset time
```

- Now, by using the **above formula** , you have to write this in **E2** and **drag it down the cells**.

```
 D4=C2-B2
```

![](https://geekexcel.com/wp-content/uploads/2021/08/create-evening-hours.png)<figcaption>Create Evening Hours</figcaption>

## Creating a sunrise-sunset chart

- You need to select the **Months and Sunrise time** column.
- Then, you have to go to the **Insert** tab.
- Now, you need to click on the **Recommended charts** under the **chart** section.

![](https://geekexcel.com/wp-content/uploads/2021/08/Click-on-chart.png)<figcaption>Click on Recommended Chart</figcaption>

- After that, you have to find the **area chart** and then select the **stacked area chart**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Click-on-stacked-area-chart.png)<figcaption>Click on the Stacked area chart</figcaption>

- You need to **right-click** on the **chart** , and click on **select data** and **select data source** dialog will open **.**
- Then, in the **legend and entries** , you have to click on **Add**.
- Now, in the **series name** , you need to **select D1** , and in the **data source** , you have to **select D2:D13** and hit **OK**.
- After that, again, you need to **right-click** on the **chart** and click on the **select data**.
- Finally, you have to click on **add and select E1** for the **series name** and for **Data select E2:E13**.

## Formatting the Sunrise Chart

- You have to **select the chart** and go to the **design tab**.
- Then, you need to choose the **chart design** with **vertical lines**.
- Now, you have to **change the colors** of different parts of the **chart**.
- After that, you need to **format the axis** and **right-click on Y-axis** and click on the **format axis option**.
- In the **axis option** , in the **major box** , you have to write this **number 0.166667** and **inbound** , you have to set **maximum value to 1.**
- Then, you need to select the **daylight part** and click on the **plus sign**.
- Now, you have to check for **data labels** and make data labels as black.
- At last, you need to **add a chart title**.

## Bottom Line

In this short tutorial, we explained how to **create a Sunrise Chart In Excel Spreadsheet**. If you have any **doubts/suggestions,** kindly drop them in the below comment section. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!!**

**Read Also:**

- **[How to add a secondary axis in Excel Office 365? – quick Tricks!!](https://geekexcel.com/how-to-add-a-secondary-axis-in-excel-office-365-quick-tricks/)**
- **[Get the Current Worksheet Name Only in Excel Office 365!!](https://geekexcel.com/get-the-current-worksheet-name-only-in-excel-office-365/)**
- **[How to create a Border on a Cell in Excel Office 365? – Easy Ways](https://geekexcel.com/how-to-create-a-border-on-a-cell-in-microsoft-excel-365/)**
- **[How to Find and Select Merged Cells in Excel Office 365?](https://geekexcel.com/how-to-find-and-select-merged-cells-in-excel-office-365/)**
- **[Change the Chart Type in Excel Office 365 ~ With Clear-Cut Examples!!](https://geekexcel.com/change-chart-type-excel/)**