ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   X Axis only showing label from a range (https://www.excelbanter.com/charts-charting-excel/149187-x-axis-only-showing-label-range.html)

JDB

X Axis only showing label from a range
 
I'm trying to create a simple column chart. I'm selecting the range E8:E11
for the X axis category labels in the wizard, but the resulting chart only
displays the text from E8 on the axis. The four columns display ok. Can
anyone help?

John Mansfield

X Axis only showing label from a range
 
On step two or four in the Wizard, look at the very bottom of the dialog box.
Make sure your X Axis data is entered into the input box titled "Category
(X) Axis Labels".

--
John Mansfield
http://cellmatrix.net





"JDB" wrote:

I'm trying to create a simple column chart. I'm selecting the range E8:E11
for the X axis category labels in the wizard, but the resulting chart only
displays the text from E8 on the axis. The four columns display ok. Can
anyone help?



All times are GMT +1. The time now is 02:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com