| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Plotting charts
Hello all
Does anyone know if there is a type of graph that allows you to plot by x-value and y-value. Much like the coordinates on a maps. The scatter chart allows you to plot by y-value, but the x-axis is by catergory. me |
|
#2
|
|||
|
|||
|
Hi,
There is an xy scatter chart type that will plot x and y as values. Cheers Andy Atogeniqua wrote: Hello all Does anyone know if there is a type of graph that allows you to plot by x-value and y-value. Much like the coordinates on a maps. The scatter chart allows you to plot by y-value, but the x-axis is by catergory. me -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#3
|
|||
|
|||
|
Thanks, I have just figured out how to do it..
Is there an easy way to label these points? thanks me |
|
#4
|
|||
|
|||
|
Hi,
The data label will display x or y value. If you want something else the try using one of these free addins to link cell contents to data labels. Rob Bovey's Chart Labeler, http://appspro.com John Walkenbach's Chart Tools, http://j-walk.com Cheers Andy Atogeniqua wrote: Thanks, I have just figured out how to do it.. Is there an easy way to label these points? thanks me -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Charts won't update | Charts and Charting in Excel | |||
| Excel Charts Linked to Spreadsheets | Charts and Charting in Excel | |||
| Can't create dynamic charts | Charts and Charting in Excel | |||
| Plotting blank cells in line charts? | Charts and Charting in Excel | |||
| Can you stop charts from plotting logic statements as 0 | Charts and Charting in Excel | |||
Linear Mode
