[Solved] Create chart with missing entries on X-
Posted: Mon Jan 22, 2018 11:58 pm
Hello all,
I am trying to create a bar chart with numbers plotted on the Y-axis as a function of the number of countries found on a certain index. Because of the spread, not all index numbers appear. That means that 0 countries are found on those index numbers.
When I create a graph over the table that I have, only the index numbers where a value is set (1 or more) appear. How can I tell the application to plot from 0 to 100 and draw no bar on those index numbers?
In small, on a range from 1 to 10, this could have been the table:
Index | Count
2 | 3
3 | 1
7 | 2
9 | 2
I would like to have an X-axis going from 0 to 10 and show bars of height 0,0,2,1,0,0,0,2,0,2,0.
Can I get Calc to draw this for me?
Note; This is my first post. I found a button "Table=" but couldn't findn an explanation in the sticky posts or via Google to tell me how to use this. If someone can help me, I will make sure to use it next time.
I am trying to create a bar chart with numbers plotted on the Y-axis as a function of the number of countries found on a certain index. Because of the spread, not all index numbers appear. That means that 0 countries are found on those index numbers.
When I create a graph over the table that I have, only the index numbers where a value is set (1 or more) appear. How can I tell the application to plot from 0 to 100 and draw no bar on those index numbers?
In small, on a range from 1 to 10, this could have been the table:
Index | Count
2 | 3
3 | 1
7 | 2
9 | 2
I would like to have an X-axis going from 0 to 10 and show bars of height 0,0,2,1,0,0,0,2,0,2,0.
Can I get Calc to draw this for me?
Note; This is my first post. I found a button "Table=" but couldn't findn an explanation in the sticky posts or via Google to tell me how to use this. If someone can help me, I will make sure to use it next time.