+ Reply to Thread
Results 1 to 6 of 6

Can you plot text on a chart? And what if I don't want a y-axis?

  1. #1
    Registered User
    Join Date
    02-02-2007
    Posts
    3

    Can you plot text on a chart? And what if I don't want a y-axis?

    This is going to sound odd, but I want to know if there is a way to make a sort of storyboard using Excel charts.

    I would need the x-axis to be days and then scenes. For instance, Day 1 Scene 1, Day 1 Scene 2, Day 1 Scene 3, Day 2 Scene 1, Day 2 Scene 2, etc.

    The chart's y-axis would be composed of characters and would consist entirely of a straight line with plot pointed on the line. They would have to be stacked, of course -- imagine a straight line along the 1, along the 2, along the 3. The only difference is the 1 would be Falchek and the 2 would be Kisten and the 3 would be Laid. Etc.

    The problem, of course, is that I'd want to set boxes of text to appear at certain points instead of simple dots. And I have no idea if it is possible to make line charts that are stacked on top of each other like that. It's basically going to be straight lines running across the chart with random chunks of text plotted across the y-axis. And I don't know how to plot more than one point along a y-axis value, because certain scenes have more than one character, so I'd need a chunk of text for Laid and another for Keat plotted on the y-axis mark for Day 1, Scene 1.

    Does any of this make sense?

    Here is an image to show the sort of thing I'm trying to get at (obviously, red is Character 1 and blue is Character 2):

    http://www.geocities.com/inpariswithyou/Image1.gif

  2. #2
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,099
    Interesting question - don't know whether it's possible, but it's amazing what you can get out of Excel. I've had a search around and maybe these links could help?

    http://peltiertech.com/Excel/ChartsH...wToBubble.html

    http://peltiertech.com/Excel/ChartsH...omMarkers.html
    oldchippy
    -------------


    Blessed are those who can give without remembering and take without forgetting

    If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

  3. #3
    Registered User
    Join Date
    02-02-2007
    Posts
    3
    Yes, I know. I spent six hours making an Excel spreadsheet to convert between the two different calendrical systems that I created for this novel. One calendar is based on a 363-day year that is divided into eleven thirty-three-day months while the other one uses a 360-day year divided into thirty-six ten-day months. The hardest part was figuring out all the math, but once I realized I need to create some sort of common ground between the two, it was cake.

    Now, I'm just trying to figure this out. I realize that I technically don't need to make a chart, that I can just use a spreadsheet to much the same effect, but it's going to be a lot harder to plot things equidistantly. I wanted to see particularly if there were large clumps of certain characters at certain areas of the year: I don't want to have six scenes of one character within one week only to have that character drop off the face of the Earth for two or three months.

    The problem, you see, is I have too many characters. Damn epics.

    But in any case, I think it's an interesting question, whether or not you can have clumps of text plot on a chart instead of simple points. And also, what to do when your y-axis is a bit funkier than the usual one. :-)

    The world may never know...

  4. #4
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,071
    Hi,

    There is a simple way to replicate your chart, in an XL spreadsheet ...
    Once you have positionned all your Text ...
    Tools > Options > View
    Clear Gridlines
    - and if need be -
    Clear Row & Column Headers
    HTH
    Carim


    Top Excel Links

  5. #5
    Registered User
    Join Date
    02-02-2007
    Posts
    3

    Smile

    Quote Originally Posted by Carim
    Hi,

    There is a simple way to replicate your chart, in an XL spreadsheet ...
    Once you have positionned all your Text ...
    Tools > Options > View
    Clear Gridlines
    - and if need be -
    Clear Row & Column Headers
    That's perfect! And you just showed me how to get rid of those pesky page breaks that appear if you click Print Preview! You didn't answer the question, really, but you found another way -- and probably an easier one -- to do just what I needed!

    Thanks a bunch!

  6. #6
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,071
    You are welcome ...

    Thanks for the feedback

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1