I don't have time to reconstruct them every week, nor do I have time to fine tune them every time we have data updates "because Excel developers think they know better than me what is needed". I haven't touched most of those charts in 18 months, even though I update the data weekly (and could do it daily, if necessary). Once the data is pulled, I change one cell on each workbook (to support 20-30 worksheets and charts), and it is done.Īll axes are setup exactly this way that I have described, because it avoids any kind of MS-trying-to-force-me-into-their-mold kind of setup. I have been working with Excel 2003 for several years in a Fortune 50 company (60,000+) making fully automated charts (700 in one project alone, all linked to pics in PPT for distribution), all tables and charts are automated, 13 week rolling data, pulling data from the mainframe. Thanks for the judgment call on what is idiotic. This seems like something that should be so simple, I shouldn't have to post on a forum to figure out.anyone have any ideas? Thanks How the hell do I do this? I'm 99% positive Excel 2004 let you set the X axis labels.did they really remove it in 2008? It also put the column B data on the Y axis like I want, but on the X axis, it just counts from 1-33. I removed the extra series (the year series), and was able to get the line to look right. And each column of data was its own series, so I had 2 lines, which, due to the scales, was basically 2 horizontal lines. I selected both columns, then I went to create a new line graph, and it created a graph that had the years (from 0-2500 even though the actual range is 1973-2005) on the Y axis, and the data on the X axis. Simple, right? It really couldn't be any less complex. In column B, I have the data.numbers that correspond to something in that year. I need to make a very, very simple line graph. This seems like something that should be so bloody simple but isn't.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |