 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / August 2006Help on adding values to a bar chart
Hello, Here is my problem. I currently have a bar chart that has 8 X-axis bars. I need to add 2 more to the X-axis. The labels for the x-axis are based on cells within another spreadsheet, but are not consecutive cells, they are spread apart. So when I go to add the two more cells, I can only add one. When I click on the second cell to add it to the list, all of the previous cells get unselected. I have even tried to manually add these two values in. Is there a limit to how many values can be on the X-axis? Please Help!!! Thanks. To select non-consecutive cells: select first cell, hold CTL key, select second cell But why not add the two data points one after the other - or do I not understand the problem. To add new data to a chart: copy data; click chart; used Edit |Paste Special: new data..... best wishes  SignatureBernard V Liengme www.stfx.ca/people/bliengme remove caps from email > Hello, > Here is my problem. I currently have a bar chart that has 8 X-axis [quoted text clipped - 7 lines] > > Thanks. I am using the Ctrl key when selecting the cells. However, when I click on the 10th cell, all of the previous cells get unselected. To me, it looks like there is a maximum number of non-consecutive cells that can be selected. I have noticed if I enter the labels manually seperating them by "label1","label2".... all of the values get displayed except the last two. This is really baffling me. Also, I tried to create a totally new graph and the same thing is happening. Thanks. > To select non-consecutive cells: select first cell, hold CTL key, select > second cell [quoted text clipped - 19 lines] > > > > Thanks. Having trouble 'seeing' this. Want to send (my private email) a sample file with some notes? SignatureBernard V Liengme www.stfx.ca/people/bliengme remove caps from email >I am using the Ctrl key when selecting the cells. However, when I > click on the 10th cell, all of the previous cells get unselected. To [quoted text clipped - 31 lines] >> > >> > Thanks. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.