Forum Discussion

MarkSL's avatar
MarkSL
Helper V
7 years ago
Solved

Column chart by Week Number issue

Hi,   I have a Line and Clustered Column chart, which charts by sales by Week Number since 01/01/2018.  This was fine for all of last year, but now that we are into 2019, Week 1 & 2 from 2019 are o...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi MarkSL,

     

    You could place both [Year] column and [Week No] column onto shared Axis, then, drill down the chart to "Year-Week No" level.

     

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi MarkSL,

 

You could place both [Year] column and [Week No] column onto shared Axis, then, drill down the chart to "Year-Week No" level.

 

Best regards,

Yuliana Gu

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I don't know about the initial author, but this definately did help me with the same question. :)