question

techresearch7777777-7743 avatar image
0 Votes"
techresearch7777777-7743 asked techresearch7777777-7743 answered

Excel 2016 Line Chart?

Hello I have Excel 2016 and have the following data:


DateMade - FileName - FileSizeInMBs
01/01/2021 - A 1000
01/01/2021 - B 2000
01/01/2021 - C 3000
01/02/2021 - A 1001
01/02/2021 - B 2002
01/02/2021 - C 3003
etc...

I want to track each unique FileName's growth over time.

  • Left vertical line represents FileSize

  • Bottom horizontal line represents DateMade

  • Main middle area represents FileName

How do I make a line chart that does this with labels?

Thanks in advance.

office-excel-itpro
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

emizhang-msft avatar image
0 Votes"
emizhang-msft answered emizhang-msft edited

Hi @techresearch7777777-7743,
You can try to create a Pivot Chart as shown in the following picture:

111342-406.png

Just checking in to see if the result was you need. Please let us know if you would like further assistance.


If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.





406.png (55.7 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

techresearch7777777-7743 avatar image
0 Votes"
techresearch7777777-7743 answered

Awesome it worked for me!

(I had a hunch it needed some type of pivot table-chart.)

That's exactly what I was aiming for.

Thanks bunch emizhang-msft for your quick and perfectly detailed-easy to follow solution.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.