Unable to Plot Values on Chart

E

elusiverunner

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 ??
 
T

Tushar Mehta

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Non Linear Scatter plot, need to find y value 3
Scatter chart with categories on x-Axis 2
Timeline Plots 0
A line chart 3
Employee Schedule not plotting properly - chart type / data series not correct 0
Data points in chart incorrect 0
Plot value at top of chart 1
Odd chart type needed 1

Top