First time using the forum. Here's what I'm trying to do:
Chart with Company Names on the x axis
Calendar years on the y axis
And want the chart itself to somehow reflect the actual calendar years spent at each company. So, perhaps a bar for Company A for 1996-2003 and a bar for Company B from 2004-2013.
I know this is not a simple bar chart' but there must be a fairly simple way to tweak Keynote to do this.
Thanks for any help.
add text boxes for the year labels as they cant be calculated in the data editor
add text boxes for the company name to appear on the bar
Plot to colums as the arrow shows
Close, but in this great example you posted, I would want the Dell bar to start at the height where the IBM bar ended, and then the Apple bar to start at the height where the Dell bar ended. Oh that and I screwed up my axes - would want to switch x and y. I've seen this type used before as a great visual on career history and I'm trying to add it to an overall career booklet I am putting together.
Thanks
I would want the Dell bar to start at the height where the IBM bar ended, and then the Apple bar to start at the height where the Dell bar ended.
This cant be done using charts as these settings are not available.
A manually created graphic will do the job easily and quicker using the shapes tool.
Please mark solved if this closes the question.
Actually what you can do is to create a "Stacked Column" chart. Use two rows as shown below. Use the ending year of the first company as value in row 2 make sure to enter 0 in row 1. In the next column enter the starting year in row 1 and in row 2 enter how many years you worked. Mark the column names as real comany names instead of Company A or B as in this example.
You will see a chart where you would have 2 columns on top of each other. Select the below column and change the opacity settings to make it invisible. You will get the "waterfall chart" as you want and shown in the image below.
Keynote chart type - trying to make a chart of career history
