# Excel 2007 Charts

**URL:** <https://boards.straightdope.com/t/excel-2007-charts/565414>\
**Category:** Factual Questions\
**Created:** [December 26, 2010, 8:03am UTC](https://boards.straightdope.com/t/excel-2007-charts/565414 "2010-12-26T08:03:20Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Shinna\_Minna\_Ma](https://avatars.discourse-cdn.com/v4/letter/s/f08c70/32.png) [@Shinna\_Minna\_Ma](https://boards.straightdope.com/u/Shinna_Minna_Ma)\
**Post date:** [December 26, 2010, 8:03am UTC](https://boards.straightdope.com/t/excel-2007-charts/565414/1 "2010-12-26T08:03:20Z")

</div>

I have three columns of data, and I want to put them into a chart. The first two columns are numbers, and the third column is percentages. I want to plot the third column on a second X-axis. I used to be able to do this in Excel 2003, but for the life of me I can’t figure out how to get this done in Excel 2007. Can anyone lend a hand? Thanks.

---

<div class="post-metadata">

**Author:** ![Bill\_Door](https://avatars.discourse-cdn.com/v4/letter/b/50afbb/32.png) [@Bill\_Door](https://boards.straightdope.com/u/Bill_Door)\
**Post date:** [December 26, 2010, 3:34pm UTC](https://boards.straightdope.com/t/excel-2007-charts/565414/2 "2010-12-26T15:34:37Z")

</div>

If you right click on the line drawn for the third data series the option for graphing on the primary or secondary axis pops up.