(Vent) Why is this program so awful?
Our take
I have to use excel for work, I chart data and utilize these charts to show individuals progress, I'm told my chart needs some condition dividing lines to indicate when certain conditions changed so that the viewers of the data can see how these changes in conditions affect the metric of performance that I am measuring. All I need is to add in a vertical line on the graph with a little label above it. And then I just need to copy this over to a word document for the progress report. WHY IS THIS SO HARD? There's no options in chart options for this, ok lets look it up. "start by adding data points to your sheet for where you want your line to go-" STOP. Why would I ever want to add in data points to my sheet just to achieve an effect on a chart? I don't want anything but my data on the sheet. Eventually I accept that is the way I have to do it. Add the data points, set x to the date I want the line to show, set y to where it should be. Follow the video tutorial exactly. Nope, chart is now broken and unreadable. I try tweaking it to see if I can just get the data to show up right, no dice. Ok lets try the more impromptu way of adding lines by just adding shapes and grouping them with the chart so I can copy it over. Excel REFUSES to group more than 2 lines. I can manage to get one grouped but not the other for some reason and not the text boxes to label this. But the main point of this rant is just the question as to why I am having to do this at all? This program has existed for almost as long as modern computers. Excel should be capable of doing all the simple chart displays and adjustments without me having to jerry rig the solution. I get that utilizing all these smaller menus and data point tricks allows for more precision but my god I should be able to find an easy way to do this and not spend my whole afternoon chasing down something that works consistently! I guess ultimately my question is how do I add a simple vertical line on 2 dates in my chart but as a greater question why is this program the way it is?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Custom error bars excel problemSo I have data for a project that I made into a line chart, which took me almost 4 hours because of the fact that excel didn't want to take my data as It was, it would see it as zero's instead of normal decimal numbers. After troubleshooting that I have another problem. I have the line graph I only need to add my custom error bars. The numerical value of the numbers should be big enough to show up, but excel just doesn't want to add them. I am selecting the range and everything correctly, I've tried with completely different numbers, different graphs and converting them etc nothing works. Please help me troubleshooting I am going insane. submitted by /u/alt_bc_im_a_pussy [link] [comments]
- How to make Line Charts automatically not start from 0?Hi guys, I am working on a calculator made in excel. It pulls the data from one sheet and in another one it displays some kpi summaries, insights and line charts. I am not happy with how the line charts look like because it always starts from 0 and my line is sitting on the top third of the chart, while the bottom two thirds are just empty space. I tried a few things, such as adding helper columns in the chart and making them invisible, to automatically adjust it every time new data is uploaded but the min is always 0 and I have control over the max only, which lowers the position of the line but makes it even more straight so it's still unappealing. I do not want to use VBA as it's something we are sending to clients, and if they do not enable macros then it's for nothing. Are there any solutions you guys might know? I am using the desktop version of excel, on mac. Thank you submitted by /u/Think_Jello_8525 [link] [comments]
- I can't insert chart?!One of my colleagues is trying to insert a chart into a very normal excel spreadsheet. When she highlights her data, the boxes grey out. So it is understanding the data is 'there' but when you go to the 'insert chart type', it is not showing you a preview of each of the charts. And when you try to create it, it isn't returning anything. When you highlight the data, it says you need to highlight the data. So it's almost like something is switched off in the background to stop her from doing that. When she emails the excel to me it works fine, any ideas? She did get a corrupted message one an excel yesterday but has used fresh excel sheets since... submitted by /u/Few_Honey7367 [link] [comments]
- Problem with getting charts to workHello, I am attempting to make a few charts for my assignment paper but excel is really not my strong suit. The core to my problem is I am trying to get error bars on my chart but i can't figure it out at all, any help would be useful. https://preview.redd.it/chh79lo3bl0h1.png?width=2768&format=png&auto=webp&s=820491ac27787a01c3a45f9fb4350ac02f999a69 I am happy to give more info i just really don't know what I'm doing. submitted by /u/yeeeeeeeeeen [link] [comments]