•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
I can't insert chart?!
Our take
It sounds like your colleague is experiencing a frustrating issue with inserting charts in Excel. Despite properly highlighting the data, the chart options grey out, preventing any previews or creations. This could indicate a background setting or a temporary glitch. Given that the charts work fine when the spreadsheet is sent to you, consider checking for any hidden settings or updates on her end. Additionally, the previous corruption message might suggest a lingering issue that needs addressing. Exploring these angles may help restore functionality.
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...
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- 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]
- Online spreadsheet stuck on loading screenI've been making a budget tracker for myself using Excel online. I've spent quite a bit of time setting it up, I've tried to add a couple charts to visualise the data but as soon as ive selected an entire column as a data source (it only has 10 values in it so far) it crashes the entire spreadsheet and it gets stuck infinitely loading. This is now the third time I've had to recreate it from scratch due to issues around charts. Is there any way I can get it to load or do I just need to give up using excel. submitted by /u/GhostDog_1314 [link] [comments]
- help me understand graphs (school assignment)https://preview.redd.it/bfro8i86sxwg1.png?width=1186&format=png&auto=webp&s=0ad03964903444767814bd9306ce52db861261e5 hello, im doing a school assigment where i need a graph and everytime i highlight my data and press "insert chart" it becomes this mess on the side and ove tried looking up how to make grpahs and it isnt working, plese help submitted by /u/memermonkey [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]
Tagged with
#Excel alternatives for data analysis#Excel compatibility#Excel alternatives#big data management in spreadsheets#generative AI for data analysis#conversational data analysis#real-time data collaboration#intelligent data visualization#data visualization tools#enterprise data management#big data performance#data analysis tools#data cleaning solutions#rows.com#modern spreadsheet innovations#machine learning in spreadsheet applications#enterprise-level spreadsheet solutions#digital transformation in spreadsheet software#google sheets#collaborative spreadsheet tools