Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
elusiverunner
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.charting
Tushar Mehta
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Only chart certain values jhorsley Charts and Charting in Excel 5 November 4th 05 04:42 PM
line chart with NA() values grime Charts and Charting in Excel 3 October 19th 05 01:56 PM
Resize chart area without resizing plot area Janwillem van Dijk Charts and Charting in Excel 2 August 2nd 05 01:52 AM
Urgent Chart Assistance Brent E Charts and Charting in Excel 1 May 10th 05 09:09 AM
line chart displays wrong values koche005 Charts and Charting in Excel 1 February 26th 05 09:43 PM


All times are GMT +1. The time now is 02:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"