ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Label in XY chart (https://www.excelbanter.com/charts-charting-excel/99858-label-xy-chart.html)

zac2170

Label in XY chart
 

I have an XY chart and wish to assign a label to the x variable from a
third column of data, is ths possible:)


--
zac2170
------------------------------------------------------------------------
zac2170's Profile: http://www.excelforum.com/member.php...o&userid=36475
View this thread: http://www.excelforum.com/showthread...hreadid=562393


roundabout

Label in XY chart
 

Right Click the Chart

Choose "Source Data" then choose the "Series" tab

Highlight the X values in the "Series" box on the left hand side

Then change the "Category (X) axis labels:" to the source of your new
labels from the third column of data

Hope this helps

Lee

zac2170 wrote:
*I have an XY chart and wish to assign a label to the x variable from
a
third column of data, is ths possible:)


--
zac2170
------------------------------------------------------------------------
zac2170's Profile:
http://www.mcse.ms/member.php?action...o&userid=36475
View this thread: http://www.mcse.ms/showthread.php?threadid=562393 *




--
roundabout
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message2423992.html



All times are GMT +1. The time now is 09:57 PM.

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