| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Replace numbers on x-axis of scatter chart with text eg 1 - one
I want to replace numbers on the x-axis of a scatter plot with text labels.
|
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Replace numbers on x-axis of scatter chart with text eg 1 - one
Hi,
You can use a similar approach as described here. http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html Cheers Andy sfran19 wrote: I want to replace numbers on the x-axis of a scatter plot with text labels. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Replace numbers on x-axis of scatter chart with text eg 1 - on
Thanks Andy,
What I want to do is replace numbers with categories on the x-axis. I'll see if I can use the approach that you describe for changing categories on the y-axis. "Andy Pope" wrote: Hi, You can use a similar approach as described here. http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html Cheers Andy sfran19 wrote: I want to replace numbers on the x-axis of a scatter plot with text labels. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Replace numbers on x-axis of scatter chart with text eg 1 - one
Perhaps the technique in this page is easier to implement:
http://peltiertech.com/Excel/Charts/DotPlot.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Andy Pope" wrote in message ... Hi, You can use a similar approach as described here. http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html Cheers Andy sfran19 wrote: I want to replace numbers on the x-axis of a scatter plot with text labels. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Scale on X & Y Axis of the scatter chart | Charts and Charting in Excel | |||
| Numbers instead of symbols on scatter chart | Charts and Charting in Excel | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Scatter chart x axis tick mark lables | Charts and Charting in Excel | |||
| the dates to label the x axis on the scatter chart won't print | Charts and Charting in Excel | |||
Linear Mode
