| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
using vlookup to get data for a chart
I have used the vlookup function to return a decimal value the is equivelent
to a test grade for my students. I would like to then plot these decimal values in a chart, however, when i try to create the chart, excel does not plot any of the decimal values. Is this because i have used the vlookup to retrieve them, any ideas? Regards Simon |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
using vlookup to get data for a chart
How are you using VLOOKUP?
Set up a range where you have your VLOOKUPs, and make the chart using this range. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "S Hendry" wrote in message ... I have used the vlookup function to return a decimal value the is equivelent to a test grade for my students. I would like to then plot these decimal values in a chart, however, when i try to create the chart, excel does not plot any of the decimal values. Is this because i have used the vlookup to retrieve them, any ideas? Regards Simon |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you link chart source data when you copy the chart? | Charts and Charting in Excel | |||
| Data showing incorrectly on line chart | Charts and Charting in Excel | |||
| Why doesn't my chart update when underlying data changes? | Charts and Charting in Excel | |||
| Activating a Chart object | Charts and Charting in Excel | |||
| Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
Linear Mode
