I have a set of data which changes often and want to run a line chart in a column rather than a row (similar to ticker tape). So far have not been able to arrange this. Is there a way to assign categories to the Y axis and values to the X axis?
Hi, It works just the same as fixing the data in a row. When you source the chart go to the series tab, click on add, and then on the button right next to the X values. Mark the columned data and continue as usual. I hope I've correctly understood your question.
The search for people who can answer your question continues for as long as needed - until you find the answer you were looking for.
When an answer is posted by someone who was invited (byYedda or by yourself) to answer your question, their answer is marked with a yellow "invited by Yedda".
To be invited to answer other people's questions in your areas of knowledge and interest, be sure to list your favorite topics:
» My Settings › My Topics.
Of course, the more helpful your answers are, the more likely you are to be invited to future questions...
Thanks for your reply.
What I want to do is have the time scale (days) on the Y axis and the values on the X axis. It is not clear how this is achieved on Excel. This is in effect turning the chart through 90 degrees but this is not possible with Excel. The usual Excel chart has the time scale on the X axis and values on the Y axis and Excel defaults to this.
Have you tried the Scatter XY chart ?
Thanks for your help - I was directed to a site peltiertech.com which had a utility for doing exactly what I wanted to do
Thanks for taking time to reply.
Got an answer for Geoff Calvert? Would you like to comment on the posted answers, or vote for the one which you think is the best?
Sign up for a free account, or sign in (if you're already a member).
Other people asked questions on similar topics, check out the answers they received:
Other people asked questions on various topics, and are still waiting for answer. Would be great if you can take a sec and answer them
