Forum Discussion

KD213141's avatar
KD213141
Copper Contributor
Apr 16, 2020

Creating a graph

Hi Guys,

 

Im trying to a graph for the below data set via a bar graph.

 

However im trying to create it so that the Date is on the x axis, the alphabets on the y axis, and the numbers only on the actual bar graph. Is this possible?

 

DateABC
1/04/2020000
2/04/2020000
3/04/2020000
6/04/2020000
7/04/2020000
8/04/2020000
9/04/2020000
10/04/2020000
13/04/2020000
14/04/2020000
15/04/2020000
16/04/2020000
17/04/2020000
20/04/2020000
21/04/2020000
22/04/2020000
23/04/2020000
24/04/2020000
27/04/2020000
28/04/2020000
29/04/2020000
30/04/2020000

 

excel

1 Reply

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Apr 17, 2020

    KD213141 You want a bar chart with date labels on the X-axis (i.e. horizontal) and labels A,B and C on the Y-axis (i.e. vertical). Now, your table only has all zeros, but suppose 1 April / A has the value of 100, where/how would you want to see that in the chart? Can you visualise how such a chart should like like? Make a drawing (by hand), photograph it and post it here.