Forum Discussion

MilwTed's avatar
MilwTed
Frequent Visitor
4 years ago
Solved

Showing proper dates in column chart

Each column is a week of sales.  I would like the X-axis to display the Sunday date from each week for each column.  Currently is just lists months.  The dataset has a Sunday date, and the sales info...
Need Help
  • HoangHugo's avatar
    HoangHugo
    4 years ago

    Hi

    In the "X axis" edit, try to choose "Categorical"

HoangHugo's avatar
HoangHugo
Icon for Solution Specialist rankSolution Specialist
4 years ago

Hi

In the "X axis" edit, try to choose "Categorical"

  • MilwTed's avatar
    MilwTed
    Frequent Visitor
    4 years ago

    Thanks, this worked.  Just a follow up -- I have the column set to short date format, but the chart still displays the long date.  Any idea how to get the chart to reflect short date?