Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Chart Dataset Selection Question

Status
Not open for further replies.

bhujanga

Programmer
Oct 18, 2007
181
US
When I create line graphs, sometimes it sets them up in such a way that the horizontal axis labels are specified in the same dialog box as the series name and the vertical data points, like the first screen shot in the attached document.
Other times it only has the series name and the series values in that dialog box and it uses the right side of the parent window for the horizontal axis values as shown in the next two shots.
When it does it the first way, the horizontal axis is associated with the values in such a way that you can size them together by dragging the extents box handle of the values. But when it does it the second way, you have to be sure to drag each one, one at a time and be sure that you don't get them out of sync. I prefer the first way usually.
The thing is, I can't figure out when it does it one way and when it does it the other way, and so I have to just hope it does it the way I want it to, but if it doesn't I can't figure out how to change it.
Can you explain what is going on to make it select one way over the other?
 
 https://files.engineering.com/getfile.aspx?folder=9e0bf1fd-24e6-4909-9359-9eb84d1b7b44&file=Excel_Chart_Question.docx
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top