Excel Forum

Displaying items with no data and displaying "0" for empty cells - 12 month rolling trend chart

Lavan Nathan

New Member

Members

Forum Posts: 1

Member Since:
November 12, 2021

Offline

November 12, 2021 - 2:09 pm

My 12-month trend chart from Nov 2020 to Oct 2021 displays trend from Jan 2020 to Dec 2021 (24 months) when "Show items with no data" and For empty cells show "0" are enabled. Please see the attached sample chart. How can I display only the trend from Nov 2020 to Oct 2021?

Thank you in advance!

Mynda Treacy

Admin

Forum Posts: 4449

Member Since:
July 16, 2010

Offline

November 12, 2021 - 7:04 pm

Hi Lavan,

Welcome to our forum!

It's not clear why you need Show Items with No Data turned on. It seems pointless to display November and December 2021 in your chart when there is no data for those periods yet.

If you want to force these periods, then you'll need to add rows to your source data for those dates with zeros for each product. When you get actual data for those periods you can remove the zero value rows.

Mynda

Forum Timezone: Australia/Brisbane

Most Users Ever Online: 245

Currently Online: Kim Knox

Guest(s) 10

Currently Browsing this Page:
1 Guest(s)

Top Posters:

SunnyKow: 1432

Anders Sehlstedt: 871

Purfleet: 412

Frans Visser: 346

David_Ng: 306

lea cohen: 219

Jessica Stewart: 204

A.Maurizio: 202

Aye Mu: 201

jaryszek: 183

Newest Members:

Maria Conatser

Jefferson Granemann

Glen Coulthard

Nikki Fox

Rachele Dickie

Raj Mattoo

Mark Luke

terimeri dooriyan

Jack Aston

AndyC

Forum Stats:

Groups: 3

Forums: 24

Topics: 6221

Posts: 27285

Member Stats:

Guest Posters: 49

Members: 31908

Moderators: 3

Admins: 4

Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT

Moderators: MOTH Support, Velouria, Riny van Eekelen