Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Unable to Plot Values on Chart
I am trying to plot two values for each day on a line chart. I have followed
procedures that I have used in other line charts that is clicking on the range of values I want, but all I get is the two axis not values - could someone help me out on this one ?? -- Steven. In God we trust, all others we virus scan. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Unable to Plot Values on Chart
It is possible that the columns are formatted as text (or the data were
somehow entered as text). Select the entire column and then Format | Cells... | Number tab. Ensure you have 'General' selected. Next, copy any empty cell. Now, select the cells containing the data you want to plot. Then, do Edit | Paste Special... | In the Operation section select Add the click OK. Now, try creating the chart again. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I am trying to plot two values for each day on a line chart. I have followed procedures that I have used in other line charts that is clicking on the range of values I want, but all I get is the two axis not values - could someone help me out on this one ?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Only chart certain values | Charts and Charting in Excel | |||
line chart with NA() values | Charts and Charting in Excel | |||
Resize chart area without resizing plot area | Charts and Charting in Excel | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
line chart displays wrong values | Charts and Charting in Excel |